I’m working with an Oracle database and have a text field of identifiers. The data I’m trying to extract is in different positions. For example:
Today = 01/11/08 and the day = Friday and it is raining
The date = 01/10/08 and the day = Thursday and we need the rain
The day after tomorrow = 01/12/08 and the day will be Monday and rain is coming
I am using INSTR to locate the beginning position for Friday, Thursday, and Monday but how do you figure out how many positions before the next ‘ ‘?
Is there something other than INSTR or can INSTR be used?
Thank you!
