csv file with a json column into a new table

[qqilihq]

@mlauber71

From my perspective the JSON format lacks the quotation marks.

Or alternatively, this approach with a Java Snippet might work (seems like that the screenshot is no longer embedded into the post, probably due to the forum migration, but the link “Bildschirmfoto” will show it):

extracting data from a piece of javascript

One can use Java's JavaScript execution engine and then create a JSON string which can then be parsed by the JSON nodes. Something like this: Table Creator Before, make sure to clean the input string before, so that brackets are balanced (your example contains more closing than opening brackets). bildschirmfoto_2017-06-22_um_20.15.57.png