|
From: | Frans Houweling |
Subject: | GET DATA DELIMITED TEXT |
Date: | Fri, 17 Jul 2015 15:33:48 +0200 |
User-agent: | Mozilla/5.0 (Windows NT 6.1; rv:31.0) Gecko/20100101 Thunderbird/31.7.0 |
Hi,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;20which 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?
Also please note that PSPPIRE generates /IMPORTCASES in the syntax instead of /IMPORTCASE and SPSS doesn't like that.
Regards frans
[Prev in Thread] | Current Thread | [Next in Thread] |