neo4j LOAD CSV with Tabs

Question

I am trying to load a csv and create nodes in neo4j 2.1.0 using the following:

USING PERIODIC COMMIT LOAD CSV FROM "file://c:/temp/listings.TXT" AS line FIELDTERMINATOR '\t' CREATE (p:person { id: line[0] });

The columns are separated using 0x9 (tab) characters. But the created nodes have the entire row content in the id.

Any help is greatly appreciated.

Answer 1

try FIELDTERMINATOR '\\t'
that's what worked for me