Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Remove preceeding zeros
Message
 
 
To
02/02/2006 12:35:57
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
01092962
Message ID:
01092964
Views:
12
? LTRIM(SUBSTR("SE7130000000001201212345",6,19),1,"0")
>
>I have a character string as below:
>
>SE7130000000001201212345
>
>I then do the following
>
>? SUBSTR("SE7130000000001201212345",6,19)
>
>which gives me
>
>0000000001201212345
>
>How can I remove the preceeding zeros with out deleting the zeros after the first number? Bear in mind the first number is not always in the same position.
>
>What I want is:
>
>1201212345
>
--sb--
Previous
Reply
Map
View

Click here to load this message in the networking platform