#995 CSV Export: Newlines in Abstrace break csv

next release
closed
Igor
Export (66)
5
2014-07-01
2011-08-23
Anonymous
No

Hello,

Newlines in an abstract are also exported to csv. This makes it very difficult to parse the file. So basically line breaks shouldn't be exported to csv, they should be replaced by a space or something like that. My JabRef version is 2.7. If there is no reason for this behavior it should be changed.

It looks like this:
BibliographyType,ISBN,Identifier,Author,Title,Journal,Volume,Number,Month,Pages,Year,Address,Note,URL,Booktitle,Chapter,Edition,Series,Editor,Publisher,ReportType,Howpublished,Institution,Organizations,School,Annote,Custom1,Custom2,Custom3,Custom4,Custom5
7,"","article","Smith, Mr","A book","C",1,,"","1",2011,"","","","","","","","","","","","","","","","Lorem
ipsum
dolor
sit
amet,
consectetur
adipiscing
elit.","","","",""

It should look like this:
BibliographyType,ISBN,Identifier,Author,Title,Journal,Volume,Number,Month,Pages,Year,Address,Note,URL,Booktitle,Chapter,Edition,Series,Editor,Publisher,ReportType,Howpublished,Institution,Organizations,School,Annote,Custom1,Custom2,Custom3,Custom4,Custom5
7,"","article","Smith, Mr","A book","C",1,,"","1",2011,"","","","","","","","","","","","","","","","Lorem ipsum dolor sit amet, consectetur adipiscing elit.","","","",""

  1. Definition of the CSV Format

While there are various specifications and implementations for the
CSV format (for ex. [4], [5], [6] and [7]), there is no formal
specification in existence, which allows for a wide variety of
interpretations of CSV files. This section documents the format that
seems to be followed by most implementations:

  1. Each record is located on a separate line, delimited by a line
    break (CRLF). For example:

    aaa,bbb,ccc CRLF
    zzz,yyy,xxx CRLF
    (See http://tools.ietf.org/html/rfc4180#page-2 )

Discussion

  • The Bibtex file to reproduce this behavior

     
    Attachments
  • Igor
    Igor
    2014-07-01

    • status: open --> closed
    • assigned_to: Igor
    • Group: --> next release