Thanks, I am thinking along those lines too. Problem is I don't have to the
technical know how to do it easily. Kind of like knowing how a jet engine
works but unable to write a manual on it in Japanese. Oh well. Guess I have
to tough it out, nothing in life is free but I have got some great snippits
here in the past. Problably take me two days to write the code. Was hoping
someone had a routine for this they could slam dunk to me.

"ras" wrote:

Parse it back-to-front
Take off the zip, if it exists plus any spaces and comma
then the state, if it exists, and any space/comma before it
then look at the next comma-separated section.
If it exists, take it and remove parenthetical text as the city.
What's left is the address...
This seems to meet your requirements.

You can also vet the state by word, abbrev, or start-of-word.
You can vet the city from a larger list, as well as lookup city by
zip, given the right list.