[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: GET DATA DELIMITED TEXT
From: |
Ben Pfaff |
Subject: |
Re: GET DATA DELIMITED TEXT |
Date: |
Mon, 20 Jul 2015 20:45:04 -0700 |
User-agent: |
Mutt/1.5.23 (2014-03-12) |
On Fri, Jul 17, 2015 at 03:33:48PM +0200, Frans Houweling wrote:
> I have had trouble reading MS Excel-generated csv files before discovering
> the /ESCAPE option. In particular an Excel file like this:
>
> uniqID|company |score
> 1 |Number one|76
> 2|"The Best" |91
> 3|Peerless Ltd |20
>
> will become a csv file like this:
>
> uniqID;company;score
> 1;Number one;76
> 2;"""The Best""";91
> 3;Peerless Ltd;20
>
> which is read by GET DATA in SPSS (version 14, sorry) but in PSPP needs the
> /ESCAPE option.
> So my question is: shouldn't the escaping behaviour be the default, and a
> /NOESCAPE option an extension?
I didn't realize that was the SPSS behavior! The documentation doesn't
mention it.
I pushed a commit to the PSPP repository that makes this the default
behavior and removes /ESCAPE entirely. I don't see a reason to add a
/NOESCAPE.
- GET DATA DELIMITED TEXT, Frans Houweling, 2015/07/17
- Message not available
- Re: GET DATA DELIMITED TEXT,
Ben Pfaff <=