SOLVED
How to remove double quotes that appears within a text
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
smrithiraj
7 - Meteor
‎02-21-2024
05:40 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
How to remove double quotes that appears within a text while ignoring the double quotes in the beginning and end of the text
Solved! Go to Solution.
Labels:
- Labels:
- Regex
4 REPLIES 4
cjaneczko
13 - Pulsar
‎02-21-2024
05:55 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Can you provide a sample of your data? Are there delimiters at the beginning and end of your strings too?
‎02-21-2024
05:58 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
‎02-21-2024
06:04 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@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
‎02-21-2024
06:06 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
You can do the following in a formula tool.
'"' + Replace(SubString([Field1], 1, Length([Field1]) - 1), '"', '') + '"'
