Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Identifying Records with non ASCII Characters

Izabela1
5 - Atom

I have a list of records that include letters, numbers, spaces, _, -, . ,etc. 

 

Is there a way to flag any records that include non ASCII Characters? 

3 REPLIES 3
benakesh
12 - Quasar

letters, numbers, spaces, _, -, . ,  are ascii .  

Can you include sample  data  with  different  flags   ?   Regex tool can be used  to identify different characters.

You can test  regular expression  here :  https://regexr.com/   

jdunkerley79
ACE Emeritus
ACE Emeritus

An expression of:

 

 

REGEX_Match(Field1,".*[^\x01-\x7F].*", 0)

 

 

will create a True if non ASCII (1-127) character are present a False otherwise.

 

Quick sample attached

Izabela1
5 - Atom

Thank you!

Labels
Top Solution Authors