How to get the substring from a column with many carriage returns
Mark1970Sep 21 2012 — edited Sep 21 2012I've got this situation.
In a not normalized table loaded with data from an excel file, I have a column containing a long string with many carriage returns so that after each of them it begins a new string I have to manipulate.
I mean, in the column PERSON I've got something like this:
PERSON
_______
Jonh
Taylor
Software developer
...
Of course I have to write a Pl/Sql procedure extracting each string and I know that each string ends with a carriage return chr(13)||chr(10)
Has someome a procedure or a function to give me that can help me?
I think I should use the INSTR built-in function but I it'd be usefeull whether some of you had something ready.
Thanks!