Extract a string

[Mary_S_(Guest)]

Using Xbase 8.1____I have a character field which has an address, city and zip. Of course the address can vary but so can the city and zip. I want to extract the city. The format for this field is____Addess city zip (1400 Elm St Anywhere 99999)____What^s the same in each field is the city is before the 5 digit zip (which can be different) but the city can be of different length. I was trying to get to it by using strsearch by starting at the end going back 6 characters (5 for the zip and the space) then going to the next space but couldn^t get it.__Any ideas?____Thanks

[Mary_S_(Guest)]

never mind - I looked back through this message board not very far and discovered the WORD function. It also worked perfectly for me.__Um, thanks.