Remove all commas from datatable

[dvn (Dubhan Conry)]

Hello everyone,

I am using a read range activity an excel file that I get from someone at work. My automation will upload that file to another program.
That excel table contains many columns with numbers and if the numbers contain commas(,) then the upload will fail.
Normally I would use “For Each Row” to check for commas and remove them but since there are many columns to check, I was wondering if there is a better solution to remove all the commas from the datatable.

Thank you.

[prasath17 (Guru)]

@dvn - Please check this post…

LINQ query to update(replace)datatable in uipath

@Rachel7 this is maybe a too quick shot as it replace any space in any column to NA and returns a datatable. But you can give a try (From r In dtData.AsEnumerable Select ia = r.ItemArray.toList Select ic = ia.ConvertAll(Function (e) e.ToString.Trim.Replace(" ","NA")).toArray() Select dtCorrected.Rows.Add(ic)).CopyToDataTable() NEW VERSION, simplified: (From r In dtData.AsEnumerable let ra = r.ItemArray.Select(Function (x) x.ToString.Trim.Replace(" ","NA")).toArray() Select dtCorrected.Rows.…

[NIVED_NAMBIAR (NIVED N)]

Hi @dvn

You can try this way too

Use this code to use in invoke code activitiy with dt1 as in/out argument

dt1.AsEnumerable().ToList().ForEach(Sub(row) row.ItemArray.ToList().ForEach(Sub(e) e.ToString.Trim.Replace(“,”,“”)))

let me know if it works for you

Regards

Nived N

Happy Automation