In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

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

How to detect if a field contain Chinese characters

Dicky_Feng
5 - Atom

There is a field in one of my table which may contain Chinese and English characters.

 

May I know how could I do to detect if the field contain Chinese characters? I would like to find out the record which contain Chinese character.

 

Thanks~

 

Dicky_Feng_0-1588735366323.png

 

 

 

3 REPLIES 3
fmvizcaino
17 - Castor
17 - Castor

Hi @Dicky_Feng ,

 

You can use the following regex expression in regex tool: [a-zA-Z]+

Example attached as well.

fmvizcaino_0-1588736818718.png

 

Best,

Fernando Vizcaino

 

Dicky_Feng
5 - Atom

Thanks~ I think it works.

 

Although it show True for English only, I could reverse the match status to indicate the field contain Chinese Character~ 

Jonathan-Sherman
15 - Aurora
15 - Aurora

Hi @Dicky_Feng,

 

You could change @fmvizcaino's expression slightly to [!a-zA-Z]+ which would stop the need to reverse your true false string.

 

Regards,

Jonathan

Labels
Top Solution Authors