Extracting a string from a field 1

[Developer2U]

I need to do some string concatenation to build a dynamic string to populate a report.

What I need to extract out is the "for DR " information out of the field. The word after for could be any number of characters in length. For example, it could be "for TRR" or "for DR/TRR" etc.

Thanks in advance.

 

[Developer2U]

I am assuming I would somehow combine the Mid$ and the Instr functions, but not sure how to do it in this case.

 

[PHV]

forWhat: Mid([the field],4+InStr([the field],'for '))

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Developer2U]

Great job PHV, you're making me look like a genius. It worked quite well. What I don't understand is the 4 ...is that taking the length of 'for ' into account?

 

[PHV]

exactly, as the instr returns the position of the f.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886