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.
Solved! Go to Solution.
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!