Split column

KNIME Analytics Platform
1

Hi,

I need help with splitting an array column into separate columns, it looks like this:

[{v={f=[{v=product_id}, {v={f=[{v=special_pack_challenge_addict}, {v=java.lang.Object@62d60de1}, {v=java.lang.Object@62d60de1}, {v=java.lang.Object@62d60de1}]}}]}}, {v={f=[{v=value}, {v={f=[{v=java.lang.Object@62d60de1}, {v=4990000}, {v=java.lang.Object@62d60de1}, {v=java.lang.Object@62d60de1}]}}]}}, {v={f=[{v=currency}, {v={f=[{v=USD}, {v=java.lang.Object@62d60de1}, {v=java.lang.Object@62d60de1}, {v=java.lang.Object@62d60de1}]}}]}}, {v={f=[{v=firebase_event_origin}, {v={f=[{v=auto}, {v=java.lang.Object@62d60de1}, {v=java.lang.Object@62d60de1}, {v=java.lang.Object@62d60de1}]}}]}}, {v={f=[{v=price}, {v={f=[{v=java.lang.Object@62d60de1}, {v=4990000}, {v=java.lang.Object@62d60de1}, {v=java.lang.Object@62d60de1}]}}]}}, {v={f=[{v=quantity}, {v={f=[{v=java.lang.Object@62d60de1}, {v=1}, {v=java.lang.Object@62d60de1}, {v=java.lang.Object@62d60de1}]}}]}}, {v={f=[{v=product_name}, {v={f=[{v=Challenge Addict}, {v=java.lang.Object@62d60de1}, {v=java.lang.Object@62d60de1}, {v=java.lang.Object@62d60de1}]}}]}}, {v={f=[{v=validated}, {v={f=[{v=java.lang.Object@62d60de1}, {v=1}, {v=java.lang.Object@62d60de1}, {v=java.lang.Object@62d60de1}]}}]}}, {v={f=[{v=firebase_conversion}, {v={f=[{v=java.lang.Object@62d60de1}, {v=1}, {v=java.lang.Object@62d60de1}, {v=java.lang.Object@62d60de1}]}}]}}]

Any help on achieving this would be very helpful.

Cheers!
PB

2

If you remove the outer [ ] you can use (,) as delimiter.
However I dont think knime has set extraction features yet.
Maybe pandas in python has a functionality, this looks similiar to a dictionary in python except your brackets.

Any information about the data format?