Re: problems importing csv files

[Benjamin Oppermann]

Hi Friedrich,

It's not working.

I used this exact command: perl -p -e 's/\r\n/,/' /media/Acer/Users/Benjamin/ownCloud/A-UNI/BA-Arbeit.SoSe2014/Daten/ver47-interessantes.csv  > /home/ben/a.csv

If I open the resulting file a.csv in Calc, it has only one line.

Then instead I tried

cd /media/Acer/Users/Benjamin/ownCloud/A-UNI/BA-Arbeit.SoSe2014/Daten/ 

and

perl -p -e 's/\r\n/,/' ver47-interessantes.csv > a.csv

The second step

grep '^Teilnehmer' a.csv > b.csv

produces an empty file though.

 

 

Am So, 2. Nov 2014, um 19:50, schrieb Friedrich Beckmann:

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.

 

Friedrich

 

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