how do i extract using mid criteria?

R

rubberman

i need to extract some text from within a field but the word i need to
extract is in the middle of the text and contains differnt amounts of
characters, therefor the MID expression does not work. i need to modify this
some how to return all text between word A and word B. Can anyone help me
with this?
 
P

pietlinden

rubberman said:
i need to extract some text from within a field but the word i need to
extract is in the middle of the text and contains differnt amounts of
characters, therefor the MID expression does not work. i need to modify this
some how to return all text between word A and word B. Can anyone help me
with this?
Click to expand...

With that description, not likely. Could you give an example or two?
for example:

I have this text: Word1 word2 word3 word4...
and I want to extract the third word each time, "word2" in this case.
 
Top