Zip Code look up

[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.

 

[tina]

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

 

[Guest]

Try this:
http://www.fmsinc.com/free/demos/index.html#TotalZipCodeDatabase

Barry