Text parsing a string with variable word counts
I need to break field Birthplace into fields BirthCity and BirthState.
Birthplace typically contains City, ST. I can use LeftWords to parse
it if Birthplace contains a one-word city, like Memphis. But how do I
parse it if it contains a two-word city, like West Memphis?
Thanks,
dp
--
This list is a free service of LassoSoft: http://www.LassoSoft.com/
Search the list archives: http://www.ListSearch.com/FileMaker/Browse/
Manage your subscription: http://www.ListSearch.com/FileMaker/