Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
TRIM leading zeros
Message
De
11/01/2011 15:41:50
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
TRIM leading zeros
Versions des environnements
Visual FoxPro:
VFP 8 SP1
Divers
Thread ID:
01495747
Message ID:
01495747
Vues:
145
Please Note: VFP 8

Is there an expression which will trim leading zeros from a character expression? The expression may contain non-numeric characters.

What I've come up with seems so convoluted there almost has to be a better way.
xx="00010012012"
? SUBSTR(xx,AT(LEFT(CHRTRAN(xx,"0",""),1),xx))
Thanks to all.........Rich
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform