community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

Remove characters like    Â

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
Comet

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

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.
Comet

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

Cheers.

Labels