neo4j cypher store array property during csv import

Viewed 1169

I need to import data from a csv of the form

id;name;targetset
1;"somenode",[1,3,5,8]
2,"someothernode",[3,8]

into the graph and I need to have targetset stored as collection (array) using cypher. I tried

USING PERIODIC COMMIT
LOAD CSV WITH HEADERS FROM "file:/mytable.csv" AS row FIELDTERMINATOR ';'
CREATE (:MyNode {id: row.id, name: row.name, targetset: row.targetset});

but it stores targetset as a string, e.g. "[1,3,5,8]". There does not seem to be a function to convert array-encoding-strings to actual arrays, like there is toInt to convert strings to integers. Is there still another possibility?

2 Answers
Related