Re: GET DATA DELIMITED TEXT

2015-07-20 Thread 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 >

Re: GET DATA DELIMITED TEXT

2015-07-18 Thread John Darrington
On Sat, Jul 18, 2015 at 11:57:20AM +0200, Frans Houweling wrote: On 18/07/2015 10:04, John Darrington wrote: Thanks for the hint, John. My problem with that (and the same goes for SPSS & Excel) is that you have no control of string lengths: combining 2 .savs from similar