| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Web lookup query (have: city+state | want: zip code)
I have a spreadsheet with various building information but it only has city and state. I was able to create a .qry file to get external data from a particular location, but it just pulls all the info - I just want to pull out the first zip (it doesn't have to be exactly correct). The idea is that I will then use a zip code to MSA (metropolitan statistical area) lookup table.
I have: City & State I want to query for: The a zip code in said city and state The contents of the .qry file: Code:
WEB 1 http://zipcodes.addresses.com/results.php?ReportType=42&qc=["City","Enter the Search Term:"]&qi=0&qk=100&qs=["State","Enter the Search Term:"] Selection=10 Formatting=None ConsecutiveDelimitersAsOne=True SingleBlockTextImport=True This is what I'm getting after using the above query method:  Click for full size - Uploaded with plasq's Skitch What I really want is just the 92801 returned. All help is greatly appreciated. Have a good day. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to change address, city, state zip code into separate columns | Excel Discussion (Misc queries) | |||
| City State Zip | Excel Discussion (Misc queries) | |||
| City State Zip | Excel Worksheet Functions | |||
| zip code to city, state function | Excel Worksheet Functions | |||
Linear Mode
