When using LOAD CSV to read a file (with Aura that file must be publicly hosted on HTTP/HTTPS or FTP - not local) which includes data with double quote characters ("), the quotes need to be escaped as 2 double quote characters
For example if your data file (courses.csv) included the following content
COURSE_ID|COURSE_TITLE 1215,"""Graphs are EveryWhere"" : An Introduction to Neo4j"
and using the folloiwng LOAD CSV command
LOAD CSV WITH HEADERS FROM "https://raw.githubusercontent.com/username/courses.csv" AS row CREATE (:Course { courseID: toInt(row.COURSE_ID), courseTitle: row.COURSE_TITLE});
the this would create a Course node with the following properties
courseID = 1215
courseTitle = "Graphs are Everywhere" : An Introduction to Neo4j
-
Last Modified: 2019-10-17 14:44:38 PDT by Dana Canzano.
-
Relevant for Neo4j Versions: 2.3, 3.0.
-
Relevant keywords LOAD CSV, quotes.
Comments
0 comments
Please sign in to leave a comment.