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]
> <javascript:>> 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.
