Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

How to remove double quotes that appears within a text

smrithiraj
7 - Meteor

How to remove double quotes that appears within a text while ignoring the double quotes in the beginning and end of the text

4 REPLIES 4
cjaneczko
13 - Pulsar

Can you provide a sample of your data? Are there delimiters at the beginning and end of your strings too?

smrithiraj
7 - Meteor

Some sample data I can give is 

"This is "within quotes" a" text" - I want to remove the second and third and fourth double quotes while retaining first and second double quotes.

binuacs
21 - Polaris

@smrithiraj @What is the expected output? You were saying remove the second double quotes and retain the second double quotes, which is confusing 

cjaneczko
13 - Pulsar

You can do the following in a formula tool.

 

'"' + Replace(SubString([Field1], 1, Length([Field1]) - 1), '"', '') + '"'

 

image.pngimage.png

Labels
Top Solution Authors