Alteryx REGEX_Replace Function: Accept literal character " ?

[Billbisco]

I'm trying to use REGEX_Replace  to turn instances of   "   into  "

Unfortunately the Syntax for REGEX_Replace requires you to put your answer into quotes

None of the below work

REGEX_Replace([High Level Project Description], "(")", " " ")  

REGEX_Replace([High Level Project Description], "(")", " \" ")  

REGEX_Replace([High Level Project Description], "(")", " ' " ' ")  

Is there anyway to make this work with the Formula Tool or will I have to use something else?

[Kenda]

Hey @Billbisco! Try this:

REGEX_Replace([High Level Project Description], """, '"')

[NicoleJohnson · Accepted solution]

Try using single quotes instead - these work interchangeably with double quotes for the purposes of identifying text or for use in formulas, etc. and are helpful when you need to include either single quotes or double quotes in a string of text.

REGEX_Replace([High Level Project Description], '(")','"')  

Hope that helps!

Cheers,

NJ 

[Billbisco]

Thank you both.  This was great!