[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: problems importing csv files
From: |
Benjamin Oppermann |
Subject: |
Re: problems importing csv files |
Date: |
Sun, 02 Nov 2014 20:28:43 +0100 |
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
- problems importing csv files, Benjamin Oppermann, 2014/11/01
- Message not available
- Re: problems importing csv files, Benjamin Oppermann, 2014/11/01
- Re: problems importing csv files, Friedrich Beckmann, 2014/11/02
- Re: problems importing csv files, Friedrich Beckmann, 2014/11/02
- Re: problems importing csv files, Friedrich Beckmann, 2014/11/02
- Re: problems importing csv files, Benjamin Oppermann, 2014/11/02
- Re: problems importing csv files, Friedrich Beckmann, 2014/11/02
- Re: problems importing csv files,
Benjamin Oppermann <=
- Re: problems importing csv files, Friedrich Beckmann, 2014/11/02
- Re: problems importing csv files, Benjamin Oppermann, 2014/11/02
- Message not available
- Re: problems importing csv files, Friedrich Beckmann, 2014/11/02
- Re: problems importing csv files, Benjamin Oppermann, 2014/11/02
- Re: problems importing csv files, Friedrich Beckmann, 2014/11/02
Re: problems importing csv files, Karl Sinn, 2014/11/03