Extract multiple strings of text where data alignment is not consistent

[love_hate_knime]

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 (8.8 KB)
e a better way! Thanks for your help & guidance.

[armingrudd]

Hi @love_hate_knime and welcome to the KNIME Community Forum,

Does this regex in Regex Split helps?
(.*)\((.*?)\.(.*)\)\s?=\s?.\s?(.*?)\s.*

(Check “Dot matches all characters” in the settings since there is a page break in the last row)

[love_hate_knime]

Thank you, this helped!