Hi All,
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§abc@test1.com§"TestUser1§2019-02-05§;
§2§10002§Test2§abc@test2.com§TestUser2§2019-02-05§;
§3§10003§Test3§abc@test3.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.