Oracle 9i - Select part of a variable length string
Posted on 2014-10-16
I am trying to select a value from the middle of a variable length string. I think SUBSTR with INSTR will work but am having trouble with the syntax
in this example string:
'10058698.325 Fatal error reported: No Item <GMAFH - 60-90161> was found. File name /u02/......'
I want to return everything after 'reported:' and before 'File' so I return:
No Item <GMAFH - 60-90161> was found
I have figured out how to use INSTR to select the up to or after the words, but can figure out how two combine both.