Replace or encode special characters in Excel

Help Studio
, ,
1

I need help with this automation, I receive some xlsx files and I need to replace all special characters in column G of this xlsx file or encode it to ‘iso-8859-15’.

This image shows a spreadsheet with columns for debit, credit, value, standard history, and complement, containing redacted information and names. (Captioned by AI)
This image shows a spreadsheet with columns for debit, credit, value, standard history, and complement, containing redacted information and names. (Captioned by AI)1118×302 90.8 KB

2

Hello @Richarlei_Reis ,

Here are steps you can follow

1. Read the data and store it in dataTable using excel read range activity
2. Use activity - For Each Row in Data Table 
       row(<Column G>) = Regex.Replace(<Column G>.ToString, "[^A-Za-z0-9\s]", "")
3. Write the data into excel which will have special characters remoed
1 Like
3

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