Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
What is the best way to remove ( and - from phone number
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
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:
01002404
Vues:
16
Maybe not BEST, but easy:
* Replace with blanks
aa = "(111) 111-111"
aa = chrtran(aa,"("," ")
aa = chrtran(aa,")"," ")
aa = chrtran(aa,"-"," ")
? aa
* Eliminate
aa = "(111) 111-111"
aa = chrtran(aa,"(","")
aa = chrtran(aa,")","")
aa = chrtran(aa,"-","")
aa = chrtran(aa," ","")
? aa
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform