Alteryx Designer

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

Remove characters like    Â

Highlighted
9 - Comet

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!

Highlighted
9 - Comet

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

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner
[^A-Za-z0-9]

Cheers,

Mark
Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and reboot. Order shall return.
Highlighted
9 - Comet

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

Cheers.

Labels