Extracting data after a specifi word in a field

[Gary1478]

Does anyone know how to extract the data in a field that begins after a specific word? For example, would like to extract all the data in a field that appears after the word "door". However, "door" is in a different position in each record. (Sometimes it is the third word and sometimes it is the fifth word) Any help would be appreciated.

Thanks.

Gary

[RodSierra]

One way is:

Middle ( doorin ; Position ( doorin ; "door" ; 1 ; 1 ) + 4 ; Length ( doorin ) - Position ( doorin ; "door" ; 1 ; 1 ) )

you can replace the literal text with a field and the +4 with the length of that field if you need to vary the text.

[Gary1478]

Great. That worked. Thank you.