Filtering records with English and non-English characters in a single field

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.

Regex

Preparation

Accepted answers

jdunkerley79

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

All comments

s_pichaipillai

@hamdylie

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

jdunkerley79

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

Shaaz

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

Shaaz

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.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15880

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703