MergedData.xlsx (9.7 KB)
In this excel i want to remove “₹” from the row it is present how can i do it

Hello @alan_prakash

1)Use read range activity. you will get a datatable output
2)use output datatable activity to convert datatable tostring(output as strVar)
4)use Text to datatable activity and give comma as delimiter. Then you will get datatable output.
5)use Write range to write the result to excel.

1 Like

(From r In DT_Data.AsEnumerable Let ra = r.ItemArray.Select(Function (x) x.ToString.Trim.Replace(“₹”,“ ”)).toArray() Select DT_Data.Rows.Add(ra)).CopyToDataTable()

try this

1 Like


You can use the below exp in invoke code. Attached workflow for ref

Example.zip (12.9 KB)

DT1.AsEnumerable.ToList.ForEach(Sub(row) row("Price")=row("Price").ToString.Replace("₹",""))


Output with no ₹

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.