Reformatting a file

urs_77 · #1 (**permalink**) 04-13-10, 14:24

Hello,

I have a file like shown below:

456
1
2
756
349

I want it to be reformatted like this:

456, 1, 2, 756, 349

How can I do this in a UNIX shell script? Is it possible in awk? If not, how can I do it in korn shell?

pdreyer · #2 (**permalink**) 04-14-10, 04:26

Code:

sed '2,$s/^/, /' myfile | tr -d '\n'

pdreyer · #3 (**permalink**) 04-14-10, 04:33

Code:

awk '{if (NR==1) {printf $1} else {printf ", " $1}}' myfile

pdreyer · #4 (**permalink**) 04-14-10, 04:36

Code:

awk '{printf x $1; x=", "}' myfile

kitaman · #5 (**permalink**) 04-14-10, 08:41

Korn shell.

Code:

#!/bin/ksh
separator=""
while read a
do
echo -e "$separator,$a\c"
separator=", "
done<myfile
echo -e "\n"

Depending on your version of echo, you may or may not need the "-e" option.

Internet Services

Web Development

Digital Marketing

Consumer Tech