Finding Non-UTF 8 Characters

[Sarath27]

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.

[Watermark]

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

[DavidSkaife · Accepted solution]

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

[Sarath27]

Dear David,

Thanks much. It works!