Removing special characters

Hi Everyone,

I'm trying to use alteryx to use special characters from my data set.
For example:
Input
â‹Birthday Party

Output
Birthday Party

I tried using the RegEx tool (RegEx_Replace([Event], "[^\w\s]", "")) but it didn't work. I think I'm not doing something correctly.

Grateful for any guidance!
S

Datasets

Regex

Output

Accepted answers

binu_acs

@suds144 one way of doing this

REGEX_Replace([Input], '[^ -~]', '')

All comments

binu_acs

@suds144 one way of doing this

REGEX_Replace([Input], '[^ -~]', '')

suds144

Thank you for the suggestion! It worked!!

suds144

Is there a glossary I can use that explains what '[^ -~]', '') translates to?

binu_acs

Breakdown of the Regex Pattern:
[^ -~]
^ &rarr; Negation (matches everything except the characters inside the brackets).
-~ &rarr; Matches the ASCII printable range (space to tilde ~, which includes letters, numbers, punctuation, and symbols).
[^ -~] &rarr; Matches any non-ASCII printable character, such as non-English letters, emojis, or special Unicode symbols.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703