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?

Alteryx REGEX_Replace Function: Accept literal character " ?

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], "(&quot;)", " " ")

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

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

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

Regex

Parse

Preparation

Accepted answers

NicoleJohnson

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], '(&quot;)','"')

Hope that helps!

Cheers,

All comments

Kenda

Hey @Billbisco! Try this:

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

NicoleJohnson

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

Hope that helps!

Cheers,

Billbisco

Thank you both. This was great!

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703