Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
What is the best way to remove ( and - from phone number
Message
De
23/03/2005 10:49:40
Mark McCasland
Midlothian, Texas, États-Unis
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
Re: What is the best way to remove ( and - from phone number
Versions des environnements
Visual FoxPro:
VFP 6 SP5
OS:
Windows XP SP2
Network:
Windows 2000 Server
Database:
MS SQL Server
Divers
Thread ID:
00998428
Message ID:
00998450
Vues:
44
>I am converting phone numbers with variou formats (111) 1111111 and 111-111-1111. What is the best way to remove the ( and - characters?
>
>Thanks,
>Doug

CHRTRAN is best because you can remove both at the same time. You can use the following to remove every non-numeric character:

lcPhone = chrtran(lcPhone, chrtran(lcPhone, '1234567890', ''), '')
Mark McCasland
Midlothian, TX USA
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform