Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Remove characters like    Â

brindhan
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!

3 REPLIES 3
brindhan
9 - Comet

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

MarqueeCrew
20 - Arcturus
20 - Arcturus
[^A-Za-z0-9]

Cheers,

Mark
Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
brindhan
9 - Comet

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

Cheers.

Labels