Replace second quotation mark(")

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?

Regex

Accepted answers

atcodedog05

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 😀👍

water.yxmd

All comments

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&quot;$2").

Greg

morr-co

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

Screen Shot 2020-11-02 at 2.42.13 PM.png

regex.yxmd

vizAlter

Hi @busybee — Try this solution:

Use a RegEx tool with Replace output method like below:

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

$1&quot;$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

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 😀👍

water.yxmd

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.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703