Regex parse for data within ( aaa)

[mlozovskaya]

Looking for syntex to parse data from (aaa) to aaa, another example (2842hgd   )aaa to 2 columns with values: 2842hgd and aaa

[CoG]

Could you just use the Text to Columns Tool? with '()' as the separator?

• Output to Rows
• Filter off Nulls
• Cross Tab to get back to columns

[flying008]

Hi, @mlozovskaya 

Maybe this is your want  by Tokenize mode?

Spoiler

[[:alnum:]]+(?=\s*\)|$)

BTW, If your string have space between front and back char in brackets like 『(abc 123)』, then the expression need to modify.