[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: |
|
| 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 \" |