YET another parsing Q...

[Tony Martin]

THE PROLOGUE

Hi kids - it's me again in the middle of a 42 hour FM coding bender...

...still using FM 5.5v1 by FORCE (yuk)

Well, here's my painfully obvious parsing question. I probably know the answer but my brain has long-since fried and I just can't come up with it.

THE QUESTION

I have records with with city, state abbreviation and zip+4 code all within the _ADDR2 field (I didn't set it up this way - honest). Here's what the data in this field looks like:

LAS VEGAS NV 89117-2450

GLENDALE CA 91209-3493

HENDERSON NV 89015-1024

STOKE-ON-TRENT KS 45109-5612

NO LAS VEGAS NV 89130-4108

MERRICK NY 10012-4054

...etc, etc, etc.

I need the city only (which always varies in # of characters, words, stc) in a separate field. How do I go about this?

I know it has something to do with the fact that the constant value here is the number of characters in the state abbreviation, space, then the zip+4, but - being as brain dead as I am right now - I can't tie it altgether into a fluid formula.

Help! : You'll be helping out an old man who has had no sleep for days. Thank you.

[comment]

Try:

LeftWords ( Address2 , WordCount ( Address2 ) - 3 )

[Tony Martin]

Worked great - thank you!