Extract a string
Posted: Thu Aug 31, 2006 7:30 pm
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