How replace , and - in all excel cells

[RajKumar_DC (RajKumar Durai)]

Hi All,

im trying replace , and - to empty space in all excel cells how can do that.

[doceluch]

Hi,

try for each row

row(index of column).ToString.Replace(“-”,“”) and the same with “,”.

[RajKumar_DC (RajKumar Durai)]

for this case not to mention this Column is constantly changing
Is there any chance of mentioning the whole sheet without header name?

[Djh (Dillan Hackett)]

Either the method @doceluch suggests, which will work particularly well when you have read the info out of excel into UiPath.

Or using excel functionality if you havent read it into UiPath and you have the Excel open (using an excel app scope), so either a pre-built macro within the excel file, or clicks in the ribbon to use the find and replace function, or send hotkey Ctrl+F to find an replace

[doceluch]

Hi,

The count of columns is constantly changing too? Or the count is still same?

[ppr (Peter Preuss)]

give a try on following:

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

using x.ToString.Trim.Replace(" - "," ").Replace(",","")

[RajKumar_DC (RajKumar Durai)]

it work

thank you so much