Linq to .trim all values in datatable’s all rows & all columns?

[ppr (Peter Preuss)]

Variation - Handles only String Datatype Columns and keeps other DataTypes

(From d In dtData.AsEnumerable()
Let ra =d.ItemArray.Select(Function (x, i) If(d.Table.Columns(i).DataType.Equals( GetType( String )), x.ToString().Trim() , x)).ToArray()
Select r = dtCorrected.Rows.Add(ra)).CopyToDataTable()

taken from:

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 - replace all cols with only String.Empty content: (From d In dtData.AsEnumerable Let ra =d.ItemArray.Select(Function (x) If(isNothing(x), Not…