how to remove specified format in string? 2

[budjo]

hello .. i have a simple problem but couldn't get around it ..

i loaded a record on a database ... with a specific field "amount"

i converted "amount" to double then used .ToString("c") :

(System.Convert.ToDouble(rows[0]["amount"])).ToString("c")

which gave me exactly what i what the amount with "$" infront of it
..

the problem now is converting the amount (with the $ on the beginning back to double type)

i tried System.Convert.ToDouble(amount) but it keeps saying

" Input string was not in a correct format" ..

so the question is how do you remove the formating you added on a string ???

tnx

 

[misterstick]

i use:

System.Convert.ToDouble(strAmount.Replace("$", string.null).Replace(",", string.null))

but i could be wrong.

mr s. <

 

[chiph]

As long as you're only storing US currency, removing the dollar-sign and the commas should work.

If you have to store & display multiple currencies, you should store two variables for each currency value -- the numeric representation, and the one that gets formatted for display to the user.

Chip H.


____________________________________________________________________
Click here to learn Ways to help with Tsunami Relief
If you want to get the best response to a question, please read FAQ222-2244 first

 

[JohnYingling]

You can also use the Parse method of Double with NumberStyles

string s = "$1,123.45";
Globalization.NumberStyles ns = (Globalization.NumberStyles.Currency);
double d = double.Parse(s, ns);

http://www.moldyoldy.com/VBComparedemo

- free online Compare/Diff of snippets

 

[budjo]

yes johnyingling solution worked .. thanks man ..