I am a newbie. I have records of first and last names that may contain English & non-English characters in a single cell, e.g. Japanese or Chinese characters with with Latin alphabets. How can I filter these records? Thanks.
Solved! Go to Solution.
there is a filter tool available under preparation
you can use it for filtering your data
if this does not help you please post some sample data , we can help you
Thanks
Saravanan
Assuming you only allow English alphabet characters then use a Filter Tool with a Custom Expression:
REGEX_Match([FirstName], "^[A-Za-z]$") && REGEX_Match([LastName], "^[A-Za-z]$")
The True output would be those names with only English characters
Hope it helps
Hi Sarav,
Can you please let me know how to separate English and Non English characters from a dataset. Below is the sample dataset.
Phrase Value
你好吗 1000
好不好 20000
这是什么? 4500
Good or Bad 876899
Old 6781
ABCD@_$%&123 67899
Thanks in Advance
It can be done using Regex_Match in Filter Tool. Use the below code.
REGEX_Match([Field 1],"[^\x00-\x7F]+")
True will give all Non English Characters.
False will give English Characters.