Removing special characters

[suds144]

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

[binuacs · Accepted solution]

@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? 

[binuacs]

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