Loop through all the cells of a datatable

[SONYC]

Hello,

I have a sample datatable below :

The target datatable will have arround 80 columns and several thousands rows.
I need to loop through all the cells of the datatable in order to check if the value contains “;” and remove that character.

Could you please help me with a LINQ query for that ?

Thank you.

[ppr (Peter Preuss)]

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.…

[ppr (Peter Preuss)]

thanks for your PM
Ensure that any Double Quote is of " and not changed e.g by copy / paste code snippets

e.g.

let ra = r.ItemArray.Select(Function (x) x.ToString.Trim.Replace(";","")).toArray()

[SONYC]

It works.

Thank you.