Re: GET DATA DELIMITED TEXT

[Ben Pfaff]

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.