Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Remove preceeding zeros
Message
From
02/02/2006 12:35:57
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Remove preceeding zeros
Miscellaneous
Thread ID:
01092962
Message ID:
01092962
Views:
65
Hi,

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

Thanks,

Ger
Next
Reply
Map
View

Click here to load this message in the networking platform