[Top][All Lists]

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: problems importing csv files

From: Friedrich Beckmann
Subject: Re: problems importing csv files
Date: Sun, 2 Nov 2014 19:50:03 +0100

Hi Ben,

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
actual data

b) <CR><LF> within the text elements inside the variable data section

Let me know if the procedure with perl and grep works.


Am 02.11.2014 um 19:03 schrieb Benjamin Oppermann <address@hidden>:

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
kindly provided.
Are they Emacs commands or terminal commands?
However I wonder why CR LF are not visible in my text editor (Kate from
Thanks, Ben

Am So, 2. Nov 2014, um 18:34, schrieb Friedrich Beckmann:
Hi Ben,

can you tell me how you produced the original csv file? There is some
about the handling of CR and LF here:



reply via email to

[Prev in Thread] Current Thread [Next in Thread]