Replace second quotation mark(")

[busybee]

I have a string in quotation marks (eg. "Water") but my string value may contain " in the middle ("Wa"ter"). I am trying to write Regex to replace the " surrounded by characters with " - "Wa"ter"

REGEX_Replace([String1], '.+(").+', """).

However, this is replacing the entire string with ". Can you recommend regex to obtain the results I want? 

[Greg_Murray]

hi @busybee 

You'll want to double check this with other examples in your  data, but this formula works for the one you presented.

REGEX_Replace([String1], '([^"]*"[^"]*)"(.*)', "$1"$2").

Greg

[morr-co]

Hi @busybee : here is an option using the regex tool rather than the formula tool. 

[vizAlter]

Hi @busybee — Try this solution:

Use a RegEx tool with Replace output method like below:

(^"\w+)(")(\w+"$)

$1"$3

If this solves your issue please mark the answer "Solved" with a Like, if not let me know!

[grazitti_sapna]

Hi @busybee,

Here is the solution to your problem.

REGEX_Replace([Field1], '([^"]*"[^"]*)"(.*)', "$1"$2")

I hope it helps.

[atcodedog05 · Accepted solution]

Hi 

Here is a workflow for the task.

Output:

Workflow:

Formula:

REGEX_Replace([Input], '([[:alpha:]]+)"([[:alpha:]]+)', '$1$2')

Hope this helps 🙂

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

[busybee]

My Input String consists of combinations of alphanumeric and non alphanumeric characters. I had to tweak your suggestion as follows to get the results. 

REGEX_Replace([Input], '(.+)"(.+)', '$1"$2')

Thank you all for your help. 

[atcodedog05]

Happy to help 🙂 @busybee 

Cheers and Happy Analyzing 😀