Splitting text contained in brackets from a column

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

Regex

Accepted answers

Here is my take on the problem mentioned.

I hope it helps

Here is my take on the problem mentioned.

I hope it helps

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

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

Philip

Hi All,

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

Stay safe

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

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

I also still chase rabbits when trying to Regex!

Cheers!