Replace one value with another in a specific column

[ppr (Peter Preuss)]

For learning purpose and explore the different options to update a column value have a look here:

How to Update Data Column Values of a Data Table | Community Blog

And fo LINQ here:

[HowTo] LINQ (VB.Net) Learning Catalogue

This topic references the different Learning HowTos related to LINQ. It will be updated on new published HowTos as well LINQ Learning: Topic LINK First Start with LINQ [HowTo] - First Start with LINQ (VB.Net) Exploring the LINQ universe [HowTo] - Exploring the LINQ Universe (VB.Net) Operator [HowTo] Overview Topic LINK Where [HowTo] LINQ - First Start # Where Operator Select work in progress Any [HowTo] LINQ – First Start # Any Operator All [HowTo] LINQ – First Start…

@Sunil_Kumar_Marri1

(From r In dtFilterTable.AsEnumerable Select ia = r.ItemArray.toList Select ic = ia.ConvertAll(Function (e) e.ToString.Trim.Replace(" Total",“”)).toArray() Select dtResult.Rows.Add(ic)).CopyToDataTable()

this statement is replacing in all columns as it is driven by the itemArray and is similar to

(From d In DtBuild.AsEnumerable()
Let ra = d.ItemArray.Select(Function (x) x.toString.Replace("Total","")).toArray
Select rc = DtOut.Rows.Add(ra)).CopyToDataTable

As applied here:

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