Clear or convert special characters in Excel

Help Activities
, ,
1

Hi,

How to convert or to clear the special character in excel,
please refer image below of special character.

image
image1629×550 51.1 KB

2

Hi @Prasaanth_S,

  1. Try the following regural expression for each row:
System.Text.RegularExpressions.Regex.Replace((currentrow(“columnname”).tostring), “[^A-Za-z0-9-/]”, “”)
  1. Try to follow this video if you need to apply the changes into the Excel file:
    https://www.youtube.com/watch?v=GG79Vbag5ZI

Hope it helps you!

3

we would recommend more to invest within the analysis of the root cause of the crashed chars. In general it comes from missetting the Character encodings and can be fixed by using the right character encodings.

Could it be the case that CSV data directly / or indirectly by using several open / save action was involved. What is the very origin source of this data?