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~
Solved! Go to Solution.
Hi @Dicky_Feng ,
You can use the following regex expression in regex tool: [a-zA-Z]+
Example attached as well.
Best,
Fernando Vizcaino
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~
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