How to detect if a field contain Chinese characters

[Dicky_Feng]

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~

[fmvizcaino · Accepted solution]

Hi @Dicky_Feng ,

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

Example attached as well.

Best,

Fernando Vizcaino

[Dicky_Feng]

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]

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