This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Debating whether or not to upgrade to the latest version of Alteryx Designer?
I have fileds that contain both english and non-english characters like ü, ö, ß. What would be a regex function to cover the non english characters.
Characters not in a-z & A-Z would be:
So you may use something like:
Because this function has a case option (default value of 1 is case insensitive), just searching for [^a-z] may work too.
You might want to add other characters to the set....
space is one that you might want along with numbers...
oh, yes... \W looks for non-word characters, but doesn't include spaces.
lots of options...
An interesting webpage on regex and unicode characters...
Based on ASCII table (http://www.asciitable.com), I would suggest the following regex:
Basically all ASCII characters where code is not between 0 and 7F
A hexadecimal escape sequence - matches the single character whose code point is 0xdd.
Customer Support Engineer