Canvertion text to Number

[Noor_Shaik]

i need to Convert TextVal=“4 617 62” into DblVal= 4,617.62

[ImPratham45 (Prathamesh Patil)]

are last two digits are always the decimal ones?

[ImPratham45 (Prathamesh Patil)]

If yes then
try this
(test.Trim.Replace(" “,”“)).Substring(0,test.Trim.Replace(” “,”“).Length-2)+”.“+(test.Trim.Replace(” “,”“)).Substring(test.Trim.Replace(” “,”").Length-2)

[1996 (Neelima G)]

Hi @Noor_Shaik,

Try below code methods:

If you want convert string to doudle

Double Variable = Double.Parse(String Variable)

Or

Using vb. Net

Dim integerNumber As Integer
integerNumber = 17843
Console.WriteLine(integerNumber.ToString("F", CultureInfo.InvariantCulture))
' Displays 17843.00

Or

String.Format(“{0:0.00}”, row(Columnname))

Or

double.Parse(string, System.Globalization.CultureInfo.InvariantCulture)

Hope this helps, if it works mark as solution.

Thanks,
Neelima.

[Noor_Shaik]

@ImPratham45 Thank you

[ImPratham45 (Prathamesh Patil)]

Most Welcome
Happy Automation!!!