Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
COUNTING CHARACTERS IN A VARIABLE
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00462068
Message ID:
00463189
Views:
14
>>I am trying to create an ascii file to send direct payments to a bank. One of my problems is that some fields have to be
>>filled with leading zeros. If I place an amount in a variable like this -
>>First I multiply the amount by 100 to convert it to cents,
>>then place it in a variable - store left(str(amount), 10) to efttotal
>>
>>I then need to know how many zeros to place in front as the field has to be filled with leading zeros.
>>
>>156.55 should end up looking like 0000015655
>>
>>Can anyone help?
>
>TRANSFORM(YourValue,"@L ##########")

Another way to fry that fish is to:

PADL(yourValue,10,'0'). I think PADL is faster
than TRANSFER and more useful in loops.
Nebraska Dept of Revenue
Previous
Reply
Map
View

Click here to load this message in the networking platform