Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Convert a text formatted currency into a numeric
Message
From
02/09/2004 11:32:02
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00938418
Message ID:
00938787
Views:
15
Thanks again... It is amazing that there are so many prebuilt functions out there, but if you wanted to look in the help menu and serch for something you want to do, you can never find them. I knew there had to be an easier way then to go through each substr value of the character removing the $ and commas to do a val() of that. This was definately a quick an easy method.

>>I can use the MTON() function to convert a currency to a numeric, but I have a text format with a currency type in it, so I would need to convert that to a currency type first. I want my final result to be a numeric starting with a character field which contains a currency value in it. When I try a val() on say 2,456, it returns 2.00. Can someone tell me a quick way to convert these to numeric values?
>
>Try
? VAL(CHRTRAN(lcStr, [,], []))
``` Appreciate a normal day, it is always better than a bad one ```

Kev
Previous
Reply
Map
View

Click here to load this message in the networking platform