Exceldoubt

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)
3)strVar.Replace(“₹”,"")
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

@alan_prakash

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("₹",""))

Input

Output with no ₹

1 Like

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