Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

General Discussions has some can't miss conversations going on right now! From conversations about automation to sharing your favorite Alteryx memes, there's something for everyone. Make it part of your community routine!

Replace Special Characters in a String

jagdeeshn
11 - Bolide

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

jrgo
13 - Pulsar
REPLACE([Field], '"', '\"')
AngelosPachis
14 - Magnetar

Hi @jagdeeshn ,

 

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

 

AngelosPachis_0-1614010246805.png

 

so

 

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

 

Cheers,

 

Angelos

AbhilashR
14 - Magnetar
14 - Magnetar

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 \" . 

Labels