Extract data left of a specific word in a field

[Gary1478]

Does anyone know how to extract the data in a field to the left of specific word? For example, would like to extract all the data in a field that appears to the left of the word "door". However, "door" is in a different position in each record.

Thanks.

Gary

[comment]

About the same as here:

http://www.fmforums.com/forum/showtopic.php?tid/196685/

Use Position() to find the first occurrence of "door", then Left() to extract the preceding text.