Menu ▾ ▴

#1136 (ok 3.2) Escape new line in CSV export

fixed
Marc Delisle
Data Export (108)
1
2013-06-11
2008-12-11
cj0
No

Many external external tools stop importing CSV files as soon as a CRLF (Carriage return + Linefeed) is signalled within the field value.

Unfortonately this even happens when field and row delimiters are not set to CRLF.

The default "Fields escape" in the export section does not escape these in value CRLF characters.

Result: the generated CSV file is not imported.

I would like to have an option that in value CR LF values are escaped, replaced with something different or just removed, to be able to import the generated CSV file.

Discussion

  • Michal Čihař

    Michal Čihař - 2009-03-03
    • summary: CRLF in value replacement (in CSV export) --> Escape new line in CSV export
     

  • Marc Delisle

    Marc Delisle - 2009-03-30
    • assigned_to: nobody --> lem9
     

  • Marc Delisle

    Marc Delisle - 2009-03-30
    • priority: 5 --> 1
    • summary: Escape new line in CSV export --> (ok 3.2) Escape new line in CSV export
    • status: open --> open-fixed
     

  • Marc Delisle

    Marc Delisle - 2009-06-15
    • status: open-fixed --> closed-fixed
     

  • Michal Čihař

    Michal Čihař - 2013-06-11
    • Status: closed-fixed --> fixed
     
MongoDB Logo MongoDB