Editing a Single Column using LINQ

[ashwin.ashok ((TheCodingTheory))]

I have a datatable which looks like this:

Id like to remove all the special characters other than digits from the Phone No. column. I know this can be achieved using a For Each, but I wanted to know whether it was possible using LINQ.

ALSO

The columns are dynamic i.e, we might not always know what all columns might be added, as I am joining several tables together.

Help would be most appreciated, thanks in advance!

Kind Regards,
Ashwin A.K

[postwick (Paul Ostwick)]

Just use a For Each. This obsession around here with avoiding For Each is pointless. It’s not a performance issue. LINQ loops anyway, it’s just hidden to you.

[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