Convert from String to Double

[Cardon_Cezar]

I extracted from an invoice the total amount to be paid as string, using Get Text: “5.961,47”.
“.” (point) is the thousands separator and “,” (comma) is the decimal separator.

How can I convert it in double? I tried Double.Parse but I receive error message: Input string was not in a correct format.

Note: I don’t really care if the thousands separator is maintained after convertion.

[Bhavik_Solanki]

@Cardon_Cezar, Have you tried Convert.ToDouble(“5.961,47”, CultureInfo.InvariantCulture).ToString?

[Priyanka_Ramesh]

Hi,
First you can try by replacing the text from “.” to “” and “,” to “.” , then you can try using Convert.toDouble(inputText)

[pattyricarte (Patty Boy)]

Hi @Cardon_Cezar

Try to put in a variable string then use this. Convert.ToDouble(Variable) then let see it.

cheers

Happy learning

[Cardon_Cezar]

Hi @Bhavik_Solanki

I get the below error:

[Cardon_Cezar]

Hi @Priyanka_Ramesh

I get the below error:
Input string was not in a correct format

[supermanPunch (Arpan)]

@Cardon_Cezar I guess you’re performing the operation in a reverse way , Try this :

Convert.ToDouble(“5.961,47”.Replace(“.”,“”).Replace(“,”,“.”))