Clean an Excel sheet of special ASCII/foreign language characters

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

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

What is the If condition to detect such characters?

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