On 1/5/2015 8:54 AM, Jeff Johnson wrote:
Or better yet, a free list of every city in the US with counties. I have a file with all zip codes and cities, but no counties.


On 1/5/2015 8:31 AM, Jeff Johnson wrote:
When parsing addresses some cities can be two or three words. Has anyone seen a list of prefixes? For example "New" in "New River" or "St." in "St. Johns".

TIA


Just so you know what it is that I am doing, I am importing addresses in a single string and I need to break them out into Address, City, State, Zip and then I need to add County.

Many times the city is abbreviated. The zip code may be missing. The state is almost always missing. It sounds easy until you sit down to do it.

Also pointed out, you can't depend on the city because it can be one, two or more names.




--
Jeff

Jeff Johnson
[email protected]
SanDC, Inc.
(623) 582-0323
SMS (602) 717-5476
Fax 623-869-0675

www.san-dc.com
www.cremationtracker.com
www.agentrelationshipmanager.com

_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[email protected]
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Reply via email to