[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 20:49:37 +0100

Hi Ben, 

in your case I would try to look at the file with vi or less. So I would do

> cd <whatever-path-it-is>
> perl -p -e 's/\r\n/,/' ver47-interessantes.csv > a.csv

Now look at the file with 

> vi a.csv

In order to quit vi type ESC :q! 

The grep command expects the case data to start with „Teilnehmer“ at the beginning of the line. You can

> grep Teilnehmer a.csv 

to see if this is the case. grep prints out lines containing that text pattern. 


Am 02.11.2014 um 20:28 schrieb Benjamin Oppermann <address@hidden>:

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/ 
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.

reply via email to

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