pspp-users
[Top][All Lists]
Advanced

[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: Mon, 3 Nov 2014 00:05:07 +0100

Hi Ben,

you can remove the linebreaks inside the cells inside calc before exporting to csv.

Use: Edit->Find&Replace

Search for: \n
Replace with: ,

Select: Other Option: Regular _expression_

Then you can export to csv with ; as delimiter

I could import that file then directly. 

Friedrich

Am 02.11.2014 um 22:11 schrieb Friedrich Beckmann <address@hidden>:

Hi Ben,

I just went online.

Friedrich

Am 02.11.2014 um 22:04 schrieb Benjamin Oppermann <address@hidden>:

Hi Friedrich,
The output of the grep command comes up empty.
Either something is not working the way it should, or (more likely) I just keep getting your instructions wrong. I have no experience working with programming tools like Vi and regular expressions, so it's easy for me to get it all wrong :-(
Would you happen to be on #pspp in IRC?
Ben
 
 
Am So, 2. Nov 2014, um 20:49, schrieb Friedrich Beckmann:
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
run 
 
> grep Teilnehmer a.csv 
 
to see if this is the case. grep prints out lines containing that text pattern. 
 
Friedrich
 
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/ 
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.
 
 
 
 
 
 

--
Friedrich Beckmann, Bismarckstraße 11, 86159 Augsburg
Tel: 0821-44923693, Mobil: 017648576782





--
Friedrich Beckmann, Bismarckstraße 11, 86159 Augsburg
Tel: 0821-44923693, Mobil: 017648576782





reply via email to

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