Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Reg Ex: remove quotes and words within them

alphabex18
8 - Asteroid

I have First and Last name data where it will contain a nickname within quotes. I want to remove that nickname and the quotes. Example: Art "Kramer" Vandalay...I want result to be Art Vandalay. 

 

I want to use the regex tool, but cant seem to get the expression right. 

Thank you

2 REPLIES 2
atcodedog05
22 - Nova
22 - Nova

Hi @alphabex18 

 

You can use Regex or formula like below.

 

Workflow:

atcodedog05_0-1635519627338.png

 

Hope this helps : )

 

csmith11
11 - Bolide

The syntax is:

 

\s".*"

 

The config is:

 

csmith11_1-1635519731291.png

 

Labels