Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Drop leading zeros
Message
From
23/02/2009 20:37:02
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
01383641
Message ID:
01383647
Views:
62
Thanks again Sergey.

>Try
>TRANSFORM(INT(VAL(fieldname)))
>
>>We have a table with a PONUM field. The field is 15 characters and when the PONUM is assigned it is padded with leading zeros.
>>
>>I've got a textbox which is used to set a filter on the cursor with this field. In the InteractiveChange event I need to put the equivalent of
>>
>>SET FILTER TO MyStripLeadingZeros(fieldname) = TRIM(this.value)
>>This would mean that, if you type a "1" all the following records would be included in the filter
>>
>>000000000000001
>>000000000000011
>>000000000000112
>>000000000010012
>>000000001122334
>>
>>If you then added a second "1" ("11") it would reduce the selected list to
>>
>>000000000000011
>>000000000000112
>>000000001122334
>>
>>I'm not happy with my version of MyStripLeadingZeros()
>>
>>Can somebody give me a reasonable efficient implementation of it????
>>
>>Thanks to all...............Rich
Previous
Reply
Map
View

Click here to load this message in the networking platform