Grab string within brackets

Question

Hi

I am trying to grab a string within brackets using Reg Ex. The output should be as below.

FieldOutputadfsdfsfaw reg asdfsdfas dsdfsdf (regulation x)regulation xasdf33 sdfsd cc (regulation yy)regulation yyasdfsdf erer reg sdfsd sdfs werwewrwer (regulation ttt)regulation ttt

I found the below solution and it works - can someone pls explain why though? How do I read this?

(.*)(?:$)(.*)(?:$)

I would have gone for (reg.*) as a regular expression. but that doesn't work.

Drussek · Accepted Answer

Much simpler regex, and the same output:

$(.*)$

seven · Accepted Answer

Hi,

I enjoy using RegEx. One of the many problems with RegEx can be incomprehensibility. If I can, I use Alteryx string functions as they are easier for others to understand.

Substring(Substring([Field], FindString([Field], '(') + 1),0,FindString(Substring([Field], FindString([Field], '(') + 1), ')'))

Something like this would do the same job. It locates the positions of the parentheses and grabs the text between them. Even though it is nested, it only takes a few minutes to unwind what is happening here.