The last word is the zipcode, the second to last word is the state. So
something like this:

Zip = middlewords (CSZ; wordcount( CSZ); 1)
State = middlewords (CSZ; wordcount( CSZ) - 1; 1)
City = middlewords (CSZ; 1; wordcount( CSZ) - 2)


Renfer wrote:
--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Howard Schlossberg (818) 883-2846
FM Professional Solutions, Inc. Los Angeles

FileMaker 8 Certified Developer
Associate Member, FileMaker Solutions Alliance

Ok guys,

Rookie filemaker guy here. I have what seems to be simple problem but
I can't get it solved.

I need to parse some text and it seems like it should be easy.

text is: (as an example)

Miami Beach FL 33139

I need to extract the city and remove the two letter state code and
the zip.

I use the filter function to removed the zip.

I'm left with: Miami Beach FL

I know I can use rightwords,1 to get FL (or the two letter state code)

But how do get to the point where I"m left with Miami Beach. (some
cities may be one, two or three words).

How can I just extract the two letter state code?

Any ideas would be appreciated

Miron

Thank you Howard, worked like a charm.

Now, to study it so I can understand it...

Thanks again, you are not an empty head!!!

Miron


On Mon, 02 Apr 2007 12:25:56 -0700, Howard Schlossberg
<howard (AT) antispahm (DOT) fmprosolutions.com> wrote: