Converting column to rows for every 3 lines in the column

kokoro · #1 05-21-2012

Hi gurus!

Please help me with this one. I have an file with the following contents:

Code:

a
b
c
d
e
f
g
h
i
j

neutronscott · #2 05-21-2012

Code:

$ awk '{printf("%s%s",$0,NR%3?",":"\n")}' input
a,b,c
d,e,f
g,h,i
j,

Scrutinizer · #3 05-21-2012

Code:

$ paste -d, - - - < infile
a,b,c
d,e,f
g,h,i
j,,

pandeesh · #4 05-21-2012

Code:

awk '{ORS=NR%3?",":"\n"}' filename

kokoro · #5 05-23-2012

thanks guys! all of these worked for me.

Thread Tools	Search this Thread
Show Printable Version Email this Page Subscribe to this Thread	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
Converting rows to column	sagar_1986	Shell Programming and Scripting	4	05-04-2012 02:07 AM
Converting entries from rows to column	atulkakrana	Shell Programming and Scripting	2	02-17-2012 02:59 AM
command for converting 4 column data to 1 column	rpf	Shell Programming and Scripting	5	12-12-2011 10:40 AM
Converting Single Column into Multiple rows	laknar	Shell Programming and Scripting	3	01-24-2009 09:40 AM
Converting Column to Rows in a Flat file	srinikal	Shell Programming and Scripting	5	10-10-2008 03:32 PM

The Following User Says Thank You to neutronscott For This Useful Post:
kokoro (05-23-2012)

The Following 2 Users Say Thank You to Scrutinizer For This Useful Post:
47shailesh (05-21-2012), kokoro (05-23-2012)

The Following User Says Thank You to pandeesh For This Useful Post:
kokoro (05-23-2012)