Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Programmatically removing zero's
Message
From
13/06/2005 09:24:16
 
 
To
13/06/2005 06:51:25
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP1
Network:
Windows 2000 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01022697
Message ID:
01022734
Views:
13
this will also delete zeros in the number like 0002001 will be 21
looak at the new trim function in vfp 9
or try: transform(val(x))


Peter

>>I have a number field which is padded with zero's. For example:
>>
>>0000012345
>>000013456
>>
>>How can I programmatically remove the zero's??
>>
>>Many Thanks
>
>Have a look at the STRTRAN command:
>
>
>STRTRAN("000013456", "0", "")
>
>
>Kev
Peter Cortiel
Previous
Reply
Map
View

Click here to load this message in the networking platform