| searching tabe character in a variable always returns zero [message #36905] |
Wed, 02 January 2002 20:42  |
sulinder singh
Messages: 10
Registered: January 2002
|
Junior Member |
|
|
Hi all,
I am reading a file using the utl_file package from oracle,
I read a line from a file which is tab separated, from the entire line that is read in the variable ,i want to find the postion of the tab character,
so i hv used the function instr, but it never gives the position of tab character, i tried searching for 't' or '~t' or simply ' ',
Does anyone know what is the character to be searched for
for e.g contents of file
-----------------------------
test tester
----------------------
i get the entire line in a variable
i'e 'test tester'
in this variable when i search for tab it fails
can anyone throw some light on this....
Thanks and Regards
Sulinder Singh
----------------------------------------------------------------------
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
