Zip Code look up

  • Thread starter Thread starter gcotterl
  • Start date Start date
G

gcotterl

I have a .TXT file with 800,000 rows. Each row has three columns:

1. a number
2. a city name
3. a Zip Code

How can I verify that:

1. The zip-codes in my file are valid zip-codes
2. The city names in my file are correct for the zip-codes.
 
you'd have to compare the file to another file where you already know the
city/zip combinations are valid. you can buy American Zip Code lists from
the US Post Office, and from various other vendors - try a Google search.

hth
 
Back
Top