Please suggest how to solve the below error in neo4j.
Error while loading data-
Neo.DatabaseError.General.UnknownError: At /home/jioapp/neo4j-enterprise-3.5.5/import/super.csv @ position 129 - there's a field starting with a quote and whereas it ends that quote there seems to be characters in that field after that ending quote. That isn't supported. This is what I read: '"e'
Query used to load data
load csv with headers from "file:///super.csv" as row with row
MERGE (a:rambo {ename:REPLACE(row.ename,'""','"')})
ON CREATE SET
a.ip=row.ip,
a.circle = row.circle
RETURN a.ename
Actually , problem is we are getting csv files from another system and consuming them in Neo4j. In short , We dont have a control over in-coming data in csv file.
So Can we use some cypher query in neo4j to handle this type of data issue?
You can try if apoc.load.csv is more tolerant, but I doubt. The ultmative solution is to ensure you get clean data from the producer, the other option is to include a call to csvclean into your data loading pipeline.