community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

Removing text within parenthesis and the parenthesis from cells

Atom

Afternoon, 

 

I trying to find a way to remove text that is at the end of each cell the exists within parenthesis.  

 

For Example 

 

Dillon Jones (DGJ)

Lewis (LP)

Jordan Caine (JC)

 

And I just want to display

 

Dillon Jones

Lewis

Jordan Caine

 

i have tried to use the regex tool but it does not seem to recognize searching for the "(" and I am not sure it that is because it is looking the countering ")"

 

Any insight would be greatly appreciated.

 

Thanks!

@dgpaul10 ( is a special regex character, so you would have to precede it with a \ to denote the actual ( character. For example:

Regex_Replace([Field1]," \(.*?\)","")

seemed to work on my end...

Atom

Worked great! 

 

Thanks! 

I'm looking the opposite solution and will you please help me.

 

Example:  I've field text as below - 

1) Data Base (DB)

2) Data Analytics (DA)

3) Big Data (BA)

 

Need the the output in the field only withing parenthesis text as below -

1) DB

2) DA

3) BA 

ACE Emeritus
ACE Emeritus

Hi

 

Slightly different process: 

 

1) use Regex tool to tokenise and extract the parenthesis. Then clean using regex tool in replacement mode. 

 

see attached. 

 

kr

Alteryx Everything, Leave no one behind.

It is working, Thank you so much.

Asteroid

Ask and you shall receive! I had totally forgotten about special chars! Using regex to build dynamic input in-db boooyah! 

Hello,


I have a similar problem to the one you solved above. Except for I have multiple parentheses in my cell. For example:

 

This (0.123%) is a (4.567%) test (95%). 

 

I want the output to be (0.123%)(4.567%)(95%). Thank you so much in advance for your help!!

Labels