Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Remove leading zeros from field
Message
From
19/04/2005 16:22:24
Sylvain Larin
Montréal, Quebec, Canada
 
 
To
19/04/2005 16:18:46
Ger Connolly
Icm Unicomp
Dublin, Ireland
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Re: Remove leading zeros from field
Miscellaneous
Thread ID:
01006351
Message ID:
01006354
Views:
16
STR (VAL ("0000012345"))
HTH

>I have a character field that contains a number.
>
>E.g.
>
>0000012345
>0012344569
>0000000365
>0000250546
>
>How do I extract the leading zeros from this field to leave me with just the following:
>
>12345
>12344569
>365
>250546
Previous
Reply
Map
View

Click here to load this message in the networking platform