Replace Special Characters in a String

Question

Hi,

I have a string  (enter "0” for No; enter “1” for Yes with a Transition; enter “2” ).

In this string how do I replace all the " with \" to get the following output:-

(enter \"0\” for No; enter \“1\” for Yes with a Transition; enter \“2\” ).

Thanks,

Jagdeesh

AbhilashR · Answer

Hi @JagdeeshN, as suggested by others, the Replace() function should help you replace " with \". The only point to keep in mind is that your original string has non-standard Alteryx quotes which Alteryx treats as a special string, in which case you will have to write some form of nested Replace function to replace “ with \" .

AngelosPachis · Answer

Hi @JagdeeshN ,

You can use a single quotation marks in the replace formula to achieve that

so

Replace([Field1],'"','\"')

Cheers,

Angelos

example.yxmd

jrgo · Answer

REPLACE([Field], '"', '\"')