|
From: | Benjamin Oppermann |
Subject: | Re: problems importing csv files |
Date: | Sun, 02 Nov 2014 22:04:22 +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.csvNow look at the file with> vi a.csvIn 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 canrun> grep Teilnehmer a.csvto see if this is the case. grep prints out lines containing that text pattern.FriedrichAm 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.csvIf I open the resulting file a.csv in Calc, it has only one line.Then instead I triedcd /media/Acer/Users/Benjamin/ownCloud/A-UNI/BA-Arbeit.SoSe2014/Daten/andperl -p -e 's/\r\n/,/' ver47-interessantes.csv > a.csvThe second stepgrep '^Teilnehmer' a.csv > b.csvproduces an empty file though.
[Prev in Thread] | Current Thread | [Next in Thread] |