Good Evening, I am not sure if this is a bug in Load CSV or is there anyway to sort it out.
When I have a double quote in the Start of any field(§"TestUser1) then it expects a closing double quote in the end, but when i have it in the middle of field then it works fine(§Test "User1) . For some reason i have a double quote in the start of the field but there is no ending double quote. file size is huge, so I can not manually remove it.
Sample Data for testing purpose only, my csv looks like below where Line 1 has the record having double quote(") in start. Please ignore the delimiter used here.
Actually speaking when my delimiter is § then it should pick the whole and work.
§SNO§EmailId§FirstName§EmailId§LastName§HiringDate§; §1§10001§Test1§email@example.com§"TestUser1§2019-02-05§; §2§10002§Test2§firstname.lastname@example.org§TestUser2§2019-02-05§; §3§10003§Test3§email@example.com§TestUser3§2019-02-05§; `LOAD CSV WITH HEADERS FROM "file:///test1.csv" AS eachLine FIELDTERMINATOR '§' WITH eachLine return eachLine limit 10` Error Message: Neo.DatabaseError.General.UnknownError: At /home/mytestapp/neo4j-enterprise-3.5.3/import/test1.csv @ position 211 - Missing end for quote (") which started on line 1 The above code works fine if the input is §"TestUser1"§ or §Test"User1§. Any help will be appreciated.