How to replace . and , in a string that is number eg:-49.768,0000 should be equal to 49,768.00

[aslam_ali1 (aslam ali)]

Hello friends, i have numbers below
5,2300 should be equal to 5.23
49.768,0000 should be equal to 49,768.00
2,0500 should be 2.05

anyone know how to solve this.

Thanks a lot in advance.

[ppr (Peter Preuss)]

when working with numberformats we recommend to handle it via CultureInfo and and not with String Manipulations.

Double.Parse(YourVar, System.Globalization.CultureInfo.CreateSpecificCulture("de-DE")).toString("N2")

[Dilli_Reddy (Candy Reddy)]

@aslam_ali1

inputNumbers As String() = {“5,2300”, “49.768,0000”, “2,0500”}

Use LINQ to process and convert the numbers

formattedNumbers As Double() = inputNumbers.Select(Function(num)

Double.Parse(num.Replace(“,”, “”).Replace(“.”, “”).Trim()) / 100).ToArray()

-Print the formatted numbers

For Each formattedNumber As Double In formattedNumbers

Console.WriteLine(formattedNumber.ToString(“0.00”))

Output:

5.23
49.77
2.05

[aslam_ali1 (aslam ali)]

Thank you so much @ppr .
Your solutions are just awesome!!!
if you also explain your code it will help a lot for the readers.