I have escaped all the single quotes by double them and delete all the smileys like you said. Now when i count(*), it reuturns 30375 but not 41879 nodes. Could you tell me, what characters I should check that affect my results. Sorry about my bad English.
On Fri, Jul 4, 2014 at 5:28 PM, Michael Hunger < [email protected]> wrote: > You have several single quotes in your file, which cause our csv reader to > continue to read until it finds the next quote. > > You have to escape those by doubling them. > > Many of them are smileys like this ":) > > LOAD CSV FROM "file:///Users/mh/Downloads/thanhvien.csv" AS line return > count(*); > > +----------+ > > | count(*) | > > +----------+ > > | 41881 | > > +----------+ > > 1 row > > > On Fri, Jul 4, 2014 at 4:57 AM, Nguyen Minh Nhut < > [email protected]> wrote: > >> Hi good guys! >> My .csv file have 41879 nodes. When i run the load csv file it just >> create 13415 nodes. >> >> This is my cypher command: >> >> USING PERIODIC COMMIT 1000 LOAD CSV FROM "file:E:/thanhvien.csv" AS line >> create (u:ThanhVien { id: line[0], HoTen : line[1] , GioiTinh: line[2], >> NgaySinh: line[3] , GioiThieuBanThan: line[4], DienThoai: line[5] , DiaChi: >> line[6] , Email: [7] , NgheNghiep: line[7] , CoQuan: line[8] , SoThichKhac: >> line[9] , Quan: line[10] , TinhTrangHonNhan: line[11] , HinhDaiDien: >> line[12] } ); >> >> Don't know why! >> >> -- >> You received this message because you are subscribed to the Google Groups >> "Neo4j" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to [email protected]. >> >> For more options, visit https://groups.google.com/d/optout. >> > > -- > You received this message because you are subscribed to a topic in the > Google Groups "Neo4j" group. > To unsubscribe from this topic, visit > https://groups.google.com/d/topic/neo4j/-S1Xdh4ZkrE/unsubscribe. > To unsubscribe from this group and all its topics, send an email to > [email protected]. > For more options, visit https://groups.google.com/d/optout. > -- You received this message because you are subscribed to the Google Groups "Neo4j" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
