find [message #19506] |
Fri, 22 March 2002 05:06 |
Richard
Messages: 44 Registered: May 2000
|
Member |
|
|
I'm trying to find a specific character number in a file: i.e. if a file has a total of 1,400,000 chars (including spaces and any other symbols), how can I quickly go to character number 142,633?
I do not mean that in the file is a reference of '142,633'
Are there any simple search strings I can use (unix or sql)?
Thanks
Richard Minns
|
|
|
Re: find [message #19509 is a reply to message #19506] |
Fri, 22 March 2002 07:18 |
oraboy
Messages: 97 Registered: October 2001
|
Member |
|
|
I dont understand how this is related to Oracle.
As you know, the most common and known editor to the UNIX world 'vi' comes with lots of option and I am sure if its something to do with file search..vi def'tly should have a command to jump to particular line or char position
if it is in database as a column..
obvisouly you can do substr(<<columnname>>,<<characterposition>>,1 ) wud give u what u need
ex: select substr(history_desc,142633,1) from history;
|
|
|