Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Data conversion question
Message
 
À
03/11/1998 20:18:02
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00154171
Message ID:
00154174
Vues:
24
>I have a character-type field with numbers and dashes in
>it. The dashes are at varying places in each string.
>I want to strip out the dashes (and trim the trailing
>spaces) and then store the resulting stripped
>numeric-only string in another field. How do I do this?

REPLACE somefield with ALLTRIM(STRTRAN(sourcefield, "-",""))
Nick Neklioudov
Universal Thread Consultant
3 times Microsoft MVP - Visual FoxPro

"I have not failed. I've just found 10,000 ways that don't work." - Thomas Edison
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform