Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Parsing a Street Address into Separate Fields
Message
De
14/08/2006 11:41:32
Dragan Nedeljkovich (En ligne)
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:
01145336
Vues:
19
>>>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

I hate those where they ask you for address, DOB, fingerprint, retina scan and DNA sample before actually mentioning whether there's a cost somewhere (no, I didn't read it through, just the number of textboxes scared me away). Couldn't they just say "we want to harvest your data first"?

back to same old

the first online autobiography, unfinished by design
What, me reckless? I'm full of recks!
Balkans, eh? Count them.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform