Finding Non-UTF 8 Characters

Hi All,

I want to get the list of Non-UTF 8 Characters in my data.

i) [•¡¤¦§¨©ª«¬-®¯±²³¶¹º»¼½¾¿‡•…‪‰‹›⁠⁰€™■･�]

ii) And any Non-English characters

Example

It can be done using Regex_Match in Filter Tool with the below code.

REGEX_Match([Field 1],"[^\x00-\x7F]+")

True will give all Non English Characters.

False will give English Characters.

But the problem is, True part gives NULL after this regex tool in Filter, pls kindly advise on this.Thanks.

Datasets

Accepted answers

Try changing the regex to ".*[^\x01-\x7F].*" which seems to work

Are you trying to get a list of those characters? Or are you trying to filter any records that have those characters?

Try changing the regex to ".*[^\x01-\x7F].*" which seems to work

Dear David,

Thanks much. It works!