Transform rows into comma seperated columns

yahoo · #1 (**permalink**) 06-09-04, 05:03

I need to transform rows into columns as below:

a
b
c
d
e
f
g

to

a,b,c,d,e,f,g

Any help greatly appreciated?

Thanks
Hemant

vgersh99 · #2 (**permalink**) 06-09-04, 07:58

nawk -v RS='' -v OFS="," '$1=$1' file

yahoo · #3 (**permalink**) 06-09-04, 08:36

Cool. This works perfect.

Thank you so much.

saurav101 · #4 (**permalink**) 06-17-04, 16:55

Could you please explain how that "awk" statement works in this case .
Thanks
Saurav

vgersh99 · #5 (**permalink**) 06-17-04, 17:59

Quote:

RS The first character of the string value of RS is
the input record separator; a newline character by
default. If RS contains more than one character,
the results are unspecified. If RS is null, then
records are separated by sequences of one or more
blank lines.

OFS The print statement output field separator; a
space character by default.

'$1=$1' - re-evaluates the records AND prints it.

Having set the RS='' makes all your records/lines appear as fields.

Specifying OFS=',' makes ',' a new field separator.

Internet Services

Web Development

Digital Marketing

Consumer Tech