bugPSPP - Bugs: bug #40605, Figure out exact treatment of line...


bug #40605: Figure out exact treatment of line ends in text files

Submitter:  Ben Pfaff <blp>
Submitted:  Sat 16 Nov 2013 07:39:03 PM UTC
Category:  System/Portable File I/O Severity:  5 - Average
Status:  None Assigned to:  None
Open/Closed:  Open Release:  None
Effort:  0.00
* Mandatory Fields

Add a New Comment Rich Markup

Sun 02 Nov 2014 06:57:17 PM UTC, comment #3: 

Here is a discussion about a csv export from a website:


Although that one seems to be really crappy containing different character encodings latin-1 and utf-8 for variable description and case data. However it also contains <CR><LF> inside variable string data. The cases themselves are separated by <LF>.

Friedrich Beckmann <beckmanf>
Group Member
Thu 23 Jan 2014 05:45:38 AM UTC, comment #2: 

I learned one thing: on a Mac, Excel
exports .csv files with CR-only line ends, and on Windows, Excel exports .csv files with CR+LF line ends.  Users expect both formats to import OK.

Ben Pfaff <blp>
Group administrator
Sat 16 Nov 2013 07:40:13 PM UTC, comment #1: 
Ben Pfaff <blp>
Group administrator
Sat 16 Nov 2013 07:39:03 PM UTC, original submission:  

At least one survey website generates text files, intended for use with SPSS, whose lines end in only CRs (not LF or CR+LF).  PSPP does not understand this format.  SPSS's behavior is not well understood in this area.

One experiment has been performed but I do not yet understand the results, so further experiments might be necessary:

Ben Pfaff <blp>
Group administrator


(Note: upload size limit is set to 16384 kB, after insertion of the required escape characters.)

Attach Files:

No files currently attached


Depends on the following items: None found

Items that depend on this one: None found


Carbon-Copy List
  • -email is unavailable- added by beckmanf (Posted a comment)
  • -email is unavailable- added by blp (Submitted the item)

    There are 0 votes so far. Votes easily highlight which items people would like to see resolved in priority, independently of the priority of the item set by tracker managers.

    Only logged-in users can vote.


    No changes have been made to this item

    Back to the top

    Powered by Savane 3.13-599c.
    Corresponding source code