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


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

Submitted by:  Ben Pfaff <blp>
Submitted on:  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

Add a New Comment (Rich Markup)

You are not logged in

Please log in, so followups can be emailed to you.


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>
Project 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>
Project Administrator
Sat 16 Nov 2013 07:40:13 PM UTC, comment #1: 
Ben Pfaff <blp>
Project 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>
Project 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)

    Do you think this task is very important?
    If so, you can add your encouragement to it.
    This task has 0 encouragements so far.

    Only logged-in users can vote.




    No changes have been made to this item

    Back to the top

    Powered by Savane 3.5