Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Register for the upcoming Live Community Q&A Session - and don't forget to submit your questions for @DeanS regarding the future role of analytics here.

Remove certain special characters

8 - Asteroid

Hi There,


I am looking to remove 2 special characters which are " & '


I have used the data cleansing tool to remove punctuation, however, it removes a few characters that I require. I have


Current Data



Required Results



I have tried the formula tool and could not see how to remove these 2 characters only. Any suggestions would be appreciated, thanks :)



ACE Emeritus
ACE Emeritus



You could also do this in a multi-field formula tool where it would look like this:



That would allow you to apply these rules to multiple fields.

The trickiest part about this is the need to exclude both double and single quotes.  I'm not sure if there is a way in Alteryx to escape one of these characters.  If there is, you could remove the second REPLACECHAR() formula.

Alteryx Certified Partner
Alteryx Certified Partner



I looked up the hexadecimal values in an ASCII table.  I then used them in a regular expression as:


REGEX_Replace([Current Data], "[\x22\x27]", '')

It works for your data.




Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and reboot. Order shall return.
ACE Emeritus
ACE Emeritus

Shows what I know, saying that there's something I'm not sure how to do in Alteryx!

This solution is smart, and makes the formula much easier to read/maintain.




On a hunch, I just tried something else that worked for me.



By using the + to concatenate the two strings, you can replace both characters using only one formula.


Whether you use RegEx or ReplaceChar is pretty much personal preference and/or based on what you find more readable, I would say.

Alteryx Partner

hey @collinjd,


I share you my workflow that may help with your problem. Please take a look.

8 - Asteroid

Thanks all for the help!

8 - Asteroid

Great thanks very much!