How about if the city is entered through an input box as the string variable
"City"? Each user will be located in a different city, and each time a list
is being parsed, it will only contain records for that city.

Jim


"Ron Rosenfeld" wrote in message
...
On Wed, 2 Jun 2010 00:14:10 -0600, "Jim Berglund"
wrote:

Thanks again, Ron.

You're welcome. Glad to help.

By the way, if the city is a variable, City, and not a selection from a
list
of known cities, could this be handled?

You will need to determine a rule that unambiguously differentiates
the City from the rest of the string.

Unless you can do that, you will need a list.

In the examples you've provided in the past, plus knowing that some
cities consist of more than one word, there seems to be too much
variability to devise a rule.