Remove characters like    Â

[brindhan]

Hello, 

I'm trying to clean out strange characters like  Â. I used regex to remove any non word character, but that didnt work. Any ideas please? Thanks!

[brindhan]

Okay, I made do with regex_replace([_CurrentField_],"[^ABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789abcdefghijklmnopqrstuvwxyz]",'') so all good.

[MarqueeCrew · Accepted solution]

[^A-Za-z0-9]

Cheers,

Mark

[brindhan]

Thanks Mark @MarqueeCrew, I knew there had to be something better haha 🙂

Cheers.