How to remove character in a data table

[shey_1234 (ShaSha)]

Hi! I am cleaning my data in excel and I want to remove all characters ’ in the table. Any advice on this would be appreciated.

e.g.
row 1: 123456’
row2: 345678’

[Pravin_Patil1 (Pravin Patil)]

If there is only one charcter then you can use

row(ColumnIndex).ToString.Replace(“'”,String.Empty)

[shey_1234 (ShaSha)]

thanks! i tried the same but it does not write back to the excel as a data table as it is assigned as a string.

[ppr (Peter Preuss)]

have a look 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.…

[shey_1234 (ShaSha)]

Thanks for the help. This works row(ColumnIndex) = row(ColumnIndex).ToString.Replace(“’”,String.Empty)