Editing a Single Column using LINQ

[ppr (Peter Preuss)]

in case of only a few columns are to update go for a for each
we can do it with a regex.replace(YourString, "\D", "")

In case of the column name / index is unclear we can iterate over the ItemArray and check if its needed (also can exclude columns within the same time)

Doing it consequently on all columns:

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

Also have a look here:
How to Update Data Column Values of a Data Table | Community Blog