How to remove double quotes that appears within a text

[smrithiraj]

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

[cjaneczko]

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

[smrithiraj]

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.

[binu_acs]

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

[cjaneczko · Accepted solution]

You can do the following in a formula tool.

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