I am trying to import a large amount of data using Cypher's new LOAD CSV tool. The problem is that one of my properties will contain some arbitrary text which contains a lot of commas in itself. A basic picture of my data would look like:
{ "id": 1234, "another_data": "data", "text": "This can have commas, so this part never gets imported!" } My generated CSV file then is laid out like: id,another_data,text 1234,data,This can have commas, so this part never gets imported! and have even tried quoting it like id,another_data,text 1234,data,"This can have commas, and this part still never gets imported!" So, using the import tool like USING PERIODIC COMMIT 50000 LOAD CSV WITH HEADERS FROM 'file:/mydata.txt' AS line CREATE (c:Comment { id: line.id, another_data: line.another_data, text: line .text }) Gives me a node resulting in { "id": 1234, "another_data": "data", "text": "This can have commas" } I only ever have one field that can have commas and have tried putting it at the end to see if it would just grab everything left over, but no luck. Ideas??? -- You received this message because you are subscribed to the Google Groups "Neo4j" group. To unsubscribe from this group and stop receiving emails from it, send an email to neo4j+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.