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?
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)