ansaurus

Question

Answer 1

+11 A:

cat file | tr  ',' '\n' > fixed.txt

tr does simple character translation (and much more but thats what its doing here). this just translates all the commas to newlines.

luke 2010-06-14 23:46:57

why the downvote?

luke 2010-06-15 00:48:35

I didn't do it, but it may be because of the gratuitous cat use. There's no need to pipe cat to tr, since tr itself can take an input file. Is there any special reason you chose to do it that way?

Peter Ajtai 2010-06-15 04:58:20

Meant to say ---> "tr itself can take the contents of a file as an argument via STDIN" -- ran out of time, and can't edit orginal comment >:[

Peter Ajtai 2010-06-15 05:10:03

i know the cat is unnecessary and it spawns an extra process, but in this case (and in many cases) it is more readable (the data flows left to right).

luke 2010-06-15 05:11:09

It's those dang dog people.

Peter Ajtai 2010-06-15 05:13:21

Answer 2

+5 A:

tr ',' '\n' < inputfile > outputfile

For left-to-right dog people:

< inputfile tr ',' '\n' > outputfile

Dennis Williamson 2010-06-14 23:48:50

Answer 3

+1 A:

Assuming that file is not on your server, this will do all the work for you in one line:

curl http://www.stopforumspam.com/downloads/bannedips.zip | gunzip -c | sed s/,/\\n/g  > bannedips.txt

You can't use unzip for this, if you want it flying through the pipes.

Thanks for the suggestion Dennis!

Peter Ajtai 2010-06-14 23:49:39

Use `gunzip -c` instead of `unzip`. `curl ... | gunzip -c | sed ...`

Dennis Williamson 2010-06-15 00:40:03

Answer 4

+1 A:

In bash you can use a while loop:

while read -d, ip; 
    do echo $ip; 
done <file.csv >output

In awk, you can get the same result with less time:

awk -v RS=, '$1' file.csv >output

marco 2010-06-14 23:58:23

ansaurus

tags:

views:

answers:

converting a csv into text

related questions