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?
Solved! Go to Solution.
Hey @Billbisco! Try this:
REGEX_Replace([High Level Project Description], """, '"')
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
Thank you both. This was great!