Extract multiple strings of text where data alignment is not consistent

I am not experienced with regex, and I maybe overthinking issue - however I have a data set which is somewhat consistent, but not every line would be the ‘same’ layout:

Here I would want the high-lighted in yellow text, up to first ‘(’ in 1 column

then I would want the alias (red underline) in another column, then the field (underlined in green) in another and so on and so forth.

When I try to do column splitter, the results aren’t very friendly - there has to b

KNIME Regex.xlsx

e a better way! Thanks for your help & guidance.