Alteryx Designer Desktop Discussions

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

RegEx Tool

SurferJim
7 - Meteor

Hi, How do I do a RegEx search and replace all the strings within last parenthesis set with blank?  Thank you!

 

Example:

I am so excited (How so?) -> I am so excited

I am so excited (How so?)  (Tell me more) -> I am so excited (How so?)

I am so excited (How so?)  (Tell me more)  (Is it because...) -> I am so excited (How so?) (Tell me more)

 

3 REPLIES 3
MarqueeCrew
20 - Arcturus
20 - Arcturus

@SurferJim ,

 

 just a guess:

 

regex_replace[[stuff],"(.*)\(.*)\)(.*)",'$1(???)$3')

 

I wasn't so sure what blank means in your replacement but this should help. 

cheers,

 

 mark

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
binay2448
11 - Bolide

Please find attached solution for the same..

SurferJim
7 - Meteor

Sorry I am a newbie and wasn't clear.  Your solution should work.  I tried a different expression using the end anchor and that worked too.  Thank you. 🙂

 

SurferJim_0-1636189587689.png

 

Labels