Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Convert a text formatted currency into a numeric
Message
De
02/09/2004 11:32:02
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00938418
Message ID:
00938787
Vues:
14
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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform