INDEX - CR/LF

[Bjorn.Selfors@kby.BERGEN-KOMMUNE.telemax.no]

In Oracle I have a field declared as long, containing lines of text separated with 
CR/LF.
I need to split this field into separate fields, one for each of the first 3 lines.
I was hoping this could be done this way;

DEFINE CRN INTEGER SIZE 2 = 13
DEFINE CRC CHARACTER SIZE 1 = CHARACTERS(CRN) Æ2:1Å
DEFINE CRINDX INTEGER SIZE 2 = INDEX(TEXT,CRC)
DEFINE LINE1 CHARACTER SIZE 60 = TEXT Æ1:CRINDX -1Å
......

but the CRINDX is always 0, indicating that the CRC was not found.

Any solutions on this?


Bjørn Selfors
Delfi Data a.s.

= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
This list is closed, thus to post to the list, you must be a subscriber.