how do i extract using mid criteria?

[Guest]

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?

 

[pietlinden]

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?

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.