thank you for the information. The commands I mention in the previous email
are terminal commands. Your file is kind of difficult because it contains:
a) two different character encodings (latin-1 and utf-8) for variable description and the
b) <CR><LF> within the text elements inside the variable data section
Let me know if the procedure with perl and grep works.
If you complete a survey that I designed for my thesis on this site:
the results are gathered by the site in the form of these csv files.
There is an alternative file that seems to be output to csv format in a
different manner - the two are labelled "abc" and "012", but I really
don't see much of a difference. I attached the alternative file with
I am horrified at the programming of these guys and recommend everyone
to do their surveys somewhere else.
From that discussion, this must be where the problem is at: "At least
one survey website generates text files, intended for use with SPSS,
whose lines end in only CRs (not LF or CR+LF). PSPP does not understand
this format. SPSS's behavior is not well understood in this area. "
I'll try to reproduce what you did in Emacs, resp. the commands you
Are they Emacs commands or terminal commands?
However I wonder why CR LF are not visible in my text editor (Kate from
Am So, 2. Nov 2014, um 18:34, schrieb Friedrich Beckmann:
Hi Ben, <ver40-012.20.csv>
can you tell me how you produced the original csv file? There is some
about the handling of CR and LF here: