Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Parsing a Street Address into Separate Fields
Message
 
À
14/08/2006 09:45:12
Dragan Nedeljkovich
Now officially retired
Zrenjanin, Serbia
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Visual FoxPro:
VFP 9
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
MS SQL Server
Divers
Thread ID:
01144790
Message ID:
01145332
Vues:
22
>>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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform