Column split (?) Regex

The cell splitter on ][ that @HansS suggested was key to breaking this up into the “records”. If you cell split with the “as list” option, you can then ungroup into rows. After that, if you want to use a regex, it can be applied to find the fields between { } marks.

As always, many ways to do it and it comes down to whatever way you find easier and works for you!

A quote I saw recently, that I cannot remember who said it, but it is so true… something along the lines of "You decide that regex is the answer to your problem… and then you have two problems… :wink: "

KNIME_column_split.knwf (13.4 KB)

6 Likes