I have a text field of identifiers. There are multiple identifiers with information I am searching for with key pieces of data I'm trying to extract 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!