[SERVER-773] mongoimport splits field on double quotes Created: 17/Mar/10  Updated: 12/Jul/16  Resolved: 22/Mar/10

Status: Closed
Project: Core Server
Component/s: Tools
Affects Version/s: 1.2.4
Fix Version/s: 1.3.5

Type: Bug Priority: Major - P3
Reporter: Andy Yaco-Mink Assignee: Mathias Stearn
Resolution: Done Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified
Environment:

os x


Attachments: File little.csv    
Participants:

 Description   

In 1.2.4 as well as the 3/17/2010 nightly, importing a csv file, I am unable to use mongoimport to import any field that contains double quotes. I've tried a few different escaping methods (see attached csv), but importing results in these records:

> db.testcsv.find()

{ "_id" : ObjectId("4ba0ea9c092e8e7a4692ce3c"), "namedfield" : "Here is a quote 1 -->", "field1" : "<--\"" } { "_id" : ObjectId("4ba0ea9c092e8e7a4692ce3d"), "namedfield" : "Here is a quote 2 -->\", "field1" : "--\"" } { "_id" : ObjectId("4ba0ea9c092e8e7a4692ce3e"), "namedfield" : "Here is a quote 3 -->\\", "field1" : "--\"" }

 Comments   
Comment by Eliot Horowitz (Inactive) [ 26/Apr/10 ]

in a release

Comment by auto [ 22/Mar/10 ]

Author:

{'login': '', 'name': 'Mathias Stearn', 'email': 'mathias@10gen.com'}

Message: mongoimport: support for escaped " in csv with either "" or \" SERVER-773
http://github.com/mongodb/mongo/commit/f816dc8419cafb9d5af92443bff43d80846b1052

Generated at Thu Feb 08 02:55:06 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.