In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

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