RE: Scanning for similar cities

["Shannon ODonnell" <sodonnell@xxxxxxxxxxxxxxxxx>]

First thing that comes to my mind is to run a comparison against a set of
control data (physical file) that contains a list of valid cities and state
and city/state and city/state/county combinations. 



-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx]
On Behalf Of steema@xxxxxxxxxxxxx
Sent: Friday, March 31, 2006 11:24 AM
To: RPG programming on the AS400 / iSeries
Subject: Scanning for similar cities

OK this one is a bit wierd.

We get some web orders and the city field is sometimes including the
county, e.g. there is Houston, there is Houston Harrison. The harder cases
might be for a city that is made up of 2 names to being w/ such as San
Antonio.  I built a logical by city but in some cases it gets subdivided.

The only issue is, how does the program know that there is a problem?

The need is for summarizing state taxes, for those of you familiar, Texas
has separate tax codes by city and county.

The user does her tallying by city tho.