Converting vertical list to horizontal list file???

[itpmguy]

Hi,
I have a text file that has values listed one below the other. Ex.:

Milwaukee
Chicago
Dallas
New York

There are about 1500 values.

I want the values to appear as:

Milwaukee, Chicago, Dallas, New York

I want 10 values per line and next 10 on the next line.

Thanks


Cheap Computer Part Supply Buying Tips

http://www.cheap-computer-part-supply.com

VOIP Phone Service Guide

http://www.ez-voip-phone-service.com

 

[mrn]

cat filename | paste - - - - - - - - - -

Mike

"Whenever I dwell for any length of time on my own shortcomings, they gradually begin to seem mild, harmless, rather engaging little things, not at all like the staring defects in other people's characters."

 

[feherke]

Hi

And an [tt]awk[/tt] way, I think I learned here, on Tek-Tips :

awk '{ORS=NR%10?", ":"\n"}1' /input/file

Feherke.

http://rootshell.be/~feherke/

 

[itpmguy]

Thanks. Both solutions are great! From mrn's solution, I wonder if there is way to put a comma after value as follows:

Milwaukee, Chicago, Dallas, New York,


Cheap Computer Part Supply Buying Tips

http://www.cheap-computer-part-supply.com

VOIP Phone Service Guide

http://www.ez-voip-phone-service.com

 

[olded]

Just for grins (replaces spaces with commas):

sed 's/ /|/g' file|xargs -n10 |sed 's/|/ /g'|sed 's/ /,/g'

Hey, it's Friday!

 

[mrn]

You could use sed to add a comma before doing the paste

sed 's/$/,/g' < file > newfile

then

cat newfile | paste - - - - - - - - -

Mike

"Whenever I dwell for any length of time on my own shortcomings, they gradually begin to seem mild, harmless, rather engaging little things, not at all like the staring defects in other people's characters."