Regex to remove unicode for fuzzy match

I am currently using REGEX_Replace(_CurrrentField_,'[^\w]', '') for all text fields. is there anyway to prevent unicode characters were not convertable?

ConvError: Fuzzy Match (29): Comments: Some Unicode characters were not convertable ("therrror ÃƒÂÃâšÂÃâÅthisisjustasamplesentencebecausethisisasamplesentecetoreplicable the error")

Regex

Fuzzy Match

Accepted answers

maleryx

Hello @afv2688

I am trying to ConvertToCodePage([_CurrentField_], 65001). will let you know the outcome.

All comments

afv2688

Hello @maleryx,

You could try using this formula:

DecomposeUnicodeForMatch([Field1])

This converts your characters.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Regards

maleryx

ConvError: Multi-Field Formula (42): DecomposeUnicodeForMatch: Some Unicode characters were not convertable ("xxxÃââœ199xx1")

ConvError: Multi-Field Formula (42): DecomposeUnicodeForMatch: Some Unicode characters were not convertable ("xαxxxxxx_x48xxx22142")

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703