Lol. True :) I will do it the right way next time. Thanks for the lesson :)
On Thursday, June 12, 2014 2:34:09 PM UTC-6, Wes Freeman wrote: > > That will work, until you have a tab in that arbitrary text. :) Then > you'll need quotes again. > > Wes > > On Thu, Jun 12, 2014 at 4:31 PM, Eric Olson <[email protected] > <javascript:>> wrote: > >> Oh, quote EVERYTHING! Haha, I see. Thanks! I just solved it differently >> though. I found out that Cypher allows you to set the delimiter, so I >> turned it into a tab-separated file. Now my import looks like: >> >> USING PERIODIC COMMIT 50000 >> FIELDTERMINATOR '\t' >> >> LOAD CSV WITH HEADERS FROM 'file:/mydata.txt' AS line >> CREATE (c:Comment { id: line.id, another_data: line.another_data, text: >> line.text }) >> >> Viola! >> >> >> On Thursday, June 12, 2014 2:26:49 PM UTC-6, Wes Freeman wrote: >> >>> You want to "quote" your CSV. From wikipedia: >>> >>> - Fields containing a line-break, double-quote, and/or commas >>> *should* be quoted. (If they are not, the file will likely be >>> impossible to process correctly). >>> >>> >>> id,another_data,text >>> "1234","data","This can have commas, so this part never gets imported!" >>> >>> On Thu, Jun 12, 2014 at 4:13 PM, Eric Olson <[email protected]> wrote: >>> >>>> I am trying to import a large amount of data using Cypher's new LOAD >>>> CSV tool. The problem is that one of my properties will contain some >>>> arbitrary text which contains a lot of commas in itself. A basic picture >>>> of >>>> my data would look like: >>>> >>>> { >>>> "id": 1234, >>>> "another_data": "data", >>>> "text": "This can have commas, so this part never gets imported!" >>>> } >>>> >>>> >>>> My generated CSV file then is laid out like: >>>> >>>> id,another_data,text >>>> 1234,data,This can have commas, so this part never gets imported! >>>> >>>> and have even tried quoting it like >>>> >>>> id,another_data,text >>>> 1234,data,"This can have commas, and this part still never gets >>>> imported!" >>>> >>>> >>>> >>>> So, using the import tool like >>>> >>>> USING PERIODIC COMMIT 50000 >>>> LOAD CSV WITH HEADERS FROM 'file:/mydata.txt' AS line >>>> CREATE (c:Comment { id: line.id, another_data: line.another_data, text: >>>> line.text }) >>>> >>>> Gives me a node resulting in >>>> >>>> { >>>> "id": 1234, >>>> "another_data": "data", >>>> "text": "This can have commas" >>>> } >>>> >>>> I only ever have one field that can have commas and have tried putting >>>> it at the end to see if it would just grab everything left over, but no >>>> luck. Ideas??? >>>> >>>> > -- 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.
