Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Changing a dollar amount to a string?
Message
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00271203
Message ID:
00271220
Views:
24
>>>>my_amt = 12.45
>>>>my_amt = str(my_amt)
>>>>
>>>>When I change my dollar amount of 12.45 to a string, I loose the
>>>>decimal point values. When I do a (?my_amt) it shows the 12
>>>>and I loose the .45.. Could someone tell me what happend to the
>>>>deciaml values?
>>>
>>>Hi Robert,
>>>
>>>In VFP 6.0, use:
>>>? TRANSFORM(my_amt)
>>>* Or
>>>? TRANSFORM(my_amt, "@$")
>>--------
>>Hi George - nice to hear from you again..
>>What I need to do is take a number (12.45) and
>>strip out the "." to make 1245, then show the implied
>>deciaml place. When I am finished, it should look like...
>>000012450 - this would be float data type of 6.3 - thanks
>
>Hi Rob,
>
>Nice to hear from you too.

Whoops, make that--
lcstring = TRANSFORM(my_amt)
lcstring = CHRTRAN(lcstring, ".", "")
lcstring = PADL(lcstring, 8, "0")
lcstring = PADR(lcstring, 9, "0")
Duh!
George

Ubi caritas et amor, deus ibi est
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform