Skip to content

Instantly share code, notes, and snippets.

@clemp

clemp/neo4j_fix_properties_from_csv.cyp

Created April 1, 2022 20:35
Show Gist options
  • Save clemp/d337053bb81d94c18b12b0ad8fd668f7 to your computer and use it in GitHub Desktop.
Save clemp/d337053bb81d94c18b12b0ad8fd668f7 to your computer and use it in GitHub Desktop.
Download ZIP
Neo4j fix property fields of nodes from csv
Raw
neo4j_fix_properties_from_csv.cyp
// one time fix to be run from Neo4j browser
:auto USING PERIODIC COMMIT 1000 LOAD CSV WITH HEADERS from <csv address> as row
MATCH
(a:Article:Mirror)
SET
a.datePublished = datetime(apoc.date.toISO8601(toInteger(row.date_published), 's'))
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment