How to change the invalid number format

[Raja.G (Mr.RPABot)]

Hi Team,

I have one datatable column values some invalid number format came so i want change correct format

Please help me anyone for this

Input:

Expected output:

Regards,
Raja G

[Yoichi]

HI,

How do we identify decimal separator and thousand separator?
If we can assume they always have two decimal places, how about the following?

Sample
Sample20240626-4.zip (9.6 KB)

Regards,

[Parvathy (PS Parvathy)]

Hi @Raja.G

=> Read Range Workbook
Output → InputDt

=> Use below syntax in Assign:

InputDt = (From row In InputDt.AsEnumerable()
           Let newDesc = If(row("Desc").tostring.Contains(","),row("Desc").ToString.Replace(".", "").Replace(",", "."), row("Desc").ToString)
           Select InputDt.Clone().LoadDataRow(New Object() {row("Name"), CDbl(newDesc)}, False)).CopyToDataTable()

=> Write Range Workbook InputDt into new sheet

Hope it helps!!

[Raja.G (Mr.RPABot)]

Hi @Parvathy and @Yoichi ,

Thank you so much working fine.

Regards,
Raja G