Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Parsing a Street Address into Separate Fields
Message
 
To
14/08/2006 09:45:12
Dragan Nedeljkovich
Now officially retired
Zrenjanin, Serbia
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01144790
Message ID:
01145332
Views:
25
>>I would strongly recommend not doing it. There are specialized programs out there for parsing addresses, including some that will convert the addresses to USPS standard format.
>>The permuations on how an address can be entered makes the programming for it extreme.
>
>And let's not forget weird street names like the "22 1/2 st" - I've seen such streets in Charlottesville and Virginia Beach.
>
>Doesn't USPS have a webservice where you can submit an address and it comes back normalized, i.e. the way they store it, even adding the four extra digits to the zip? I think I saw it mentioned here once.

Yes, they do. But do check the terms of usage.
http://www.usps.com/webtools/?from=zclsearch&page=webtools
and
http://www.usps.com/webtools/address.htm
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform