To Remove unwanted character in xlsx

[supermanPunch (Arpan)]

Hi @NISHITHA ,

In the process of converting from CSV to Excel, do you have datatable as the intermittent value, if so we could maybe try converting using the Linq Expression mentioned in the post below :

Replace quotes in a string

have a look here: Prepare dtCorrected as described: dtCorrected = dtData.Clone (From r In dtData.AsEnumerable let ra = r.ItemArray.Select(Function (x) x.ToString.Trim.Replace("""","")).toArray() Select dtCorrected.Rows.Add(ra)).CopyToDataTable()

For your case :

dtCorrected = (From r In dtData.AsEnumerable
let ra = r.ItemArray.Select(Function (x) x.ToString.Trim.Replace("""","").Replace("=","")).toArray()
Select dtCorrected.Rows.Add(ra)).CopyToDataTable()

Another Option would be to use Modern Excel Replace Activity which will effect the Excel sheet directly :