community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

Filter for all records containing special characters

Atom

Is there a way I can filter a column for all values containing special characters?  My data contains "comments" in a variety of different languages and I am looking for a way to separate the English comments from the non-English ones.

ACE Emeritus
ACE Emeritus

Hi @kthuang,

If you use the Tokenize tool (or Formula tool with one of the REGEX functions), with...

[^\x00-\x7F]+

... does that work?  It should isolate any unusual characters.

Hope that helps!

John

 

 

 

 

Labels