Re: PSPP-BUG: importing .cvs and .txt files

[Ben Pfaff]

On Mon, Jan 20, 2014 at 09:01:49AM +0000, M?ller, Andre wrote:
> > -----Original Message-----
> > From: address@hidden
> > [mailto:address@hidden On
> > Behalf Of Susan Ford
> > Sent: Saturday, January 18, 2014 22:22
> > To: address@hidden
> > Subject: PSPP-BUG: importing .cvs and .txt files
> > 
> > MacBook Pro, Mac OS 10.7.5, PSPP 0.8.2. rev 0 MD5
> > 
> > When I import from a .cvs (or .txt) file made in Excel, PSPP tells me that
> > there is one line of text only, despite the fact that there are many.  I am
> > unable to "select" the first line - all the lines are highlighted.  All 
> > data -
> > string or numeric - appear as variables of a single "case".
> > 
> > Also, the copy and paste functions do not work.
> > 
> > Please advise.
> > 
> > Thanks,
> 
> This most probably is an issue with file encoding.
> (Mac vs. Windows)
> A tool like dos2unix or many editors will convert the file (endings) for you.

This is really odd, because PSPP is designed to work OK with both
Windows and DOS line endings.  Maybe Excel on Mac uses old Mac style
line endings by default; I thought that those were now out of style, so
PSPP doesn't handle them well.

Can someone who has a Mac and Excel (Jeremy?) please try exporting a
file to .csv or .txt in Excel?  The contents do not matter, except that
the file should have at least a few rows.  Then run "hexdump -C" on the
generated file and paste the output into an email.

Thanks,

Ben.