Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Parsing a Street Address into Separate Fields
Message
De
11/08/2006 10:14:00
 
 
À
11/08/2006 10:02:34
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:
01144797
Vues:
28
This message has been marked as a message which has helped to the initial question of the thread.
>This must've been done a thousand times already. I have parsed addresses before but I cannot seem to wrap my head around this today. (Friday)
>
>Some examples of user typed values:
>
>100 N Main St
>3001 No W Rubick Ave     && number=3001, st_prefix = No, Street=W Rubick, st_type = Ave
>12 Sycamore Dairy Rd NW  && number = 12, street=Sycamore Dairy, st_type=Rd, st_suffix = NW
>1312 S Cain St E Suite A10 && number = 1313, st_prefix=S, street=Cain, st_type=St, st_suffix=E, apt_room=Suite A10
>100 N Main St NW Ste 110
>210 Jones Dr Apt 1E
>8700 Smith Rd
>
>Parse the values typed above into these fields:
>
>number c(10)        && 100, 3001, 12, 1312, 100, 210, ...
>st_prefix c(10)     && NW, S, E, NE...
>street c(30)        && Main, Cain, ...
>st_type c(10)       && Blvd, ST, AV, ...
>st_suffix c(10)     && NW, S, E, NE, ...
>apt_room c(10)      && Apt 102, Suite 109, etc...
>
>
>Anyone up to the task on a Friday?
>
>TIA,
>Tracy

Tracy,

alines()
getwordcount()
getwordnum()

??
Gregory
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform