Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Parsing a Street Address into Separate Fields
Message
De
11/08/2006 13:24:01
Jim Winter
Jim Winter Consulting
Hinesburg, Vermont, États-Unis
 
 
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:
01144880
Vues:
30
>>But, if you include the city, state and zip on the next line, ie. [1312 S Caom St E Suite A10] + CHR(13) + [City, State Zip], it handles it just fine.
>>
>>The one thing it doesn't seem to handle very well is separating out PO Boxes from street addresses.
>>
>>Regards,
>
>It doesn't break street to pieces as Tracy requires. It's not an easy task without supporting lookup tables.
>
>Try it with [1312 S Caom St E Suite A10] + CHR(13) + [Kew Gardens, NY, 11415]

That's true, but I don't think its designed to do that.

Regards,
Jim
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform