Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Andy Uttley, Alteryx ACE, makes music with Alteryx | Math + Music
SOLVED

Splitting text contained in brackets from a column

Highlighted
8 - Asteroid

Hi,

 

Reg Ex is something that defeats me every time, mainly because I cannot get my head around the actual expression.

 

My requirement is to take the data included in the last set of brackets and put it in a separate column, so the data I currently have:

 

Name
System 1 PreProd(Rev8-30-9304E-30)

System 2 Pre-Prod - 24275 (E32)(Rev8-30-9304E-32)

System 3 SANDPIT (Test pack)(Rev8-30-9304E-32)

 

How I would like it to look:

 

Name                                                                Version                           Iteration
System 1 PreProd                                             Rev8-30-9304                E-30

System 2 Pre-Prod - 24275 (E32)                     Rev8-30-9304                E-32

System 3 SANDPIT (Test pack)                        Rev8-30-9304                E-32

 

Could anyone advise me if I should use text to columns or Reg Ex, if Reg Ex, how should I write the expression.

 

TIA

Highlighted
Alteryx Partner

Hi @Bigmonki ,

 

Here is my take on the problem mentioned.

 

I hope it helps

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

This expression in the RegEx Tool (set to Parse) might also work,

 

(.*)\((.*)(\w-\d+)

 

Philip 

Highlighted
8 - Asteroid

Hi All,

 

Thanks for your help, sometimes it is harder to see the simple stuff. Problem solved.

 

Stay safe

Highlighted
12 - Quasar

Hi, @Bigmonki 

 

Great! @grazitti_sapna  and @PhilipMannering  already helped you out.

 

Here is a link to help you see what the regex is doing:

https://regexr.com/

 

I also still chase rabbits when trying to Regex!

Cheers!

Labels