Clean an Excel sheet of special ASCII/foreign language characters

Help
1

Hi, anyone have a sample workflow to clean an Excel sheet of special ASCII and foreign language characters? Thanks

2

inside for each row, if characters exist, replace with blank… using assign activity

3

What is the If condition to detect such characters?

4

Hey @DEATHFISH

you can use Regex for this to allow your wanted chars like -
A-Z or a-z (uppercase or lowercase),numbers like (0-9), underscore (_), white space ( ), % or the dot sign (.) and many more. rest will be ignored.

Regex.Replace(yourinputStringVariable, "[^a-zA-Z0-9% ._]", string.Empty)

Regards…!!
Aksh

1 Like