Shell Programming and Scripting

Hi Experts,

I need an urgent help in replacing newline characters in my single column file by a comma.

I am using following command for this purpose:

Code:

sed -n -e 'H;${x;s/\n/,/g;s/^,//;p;}' parameter.rtf | rev | cut -c 4- | rev

My input file has:

Code:

TABLE_1
TABLE_2
TABLE_3

What I need:

Code:

TABLE_1,TABLE_2,TABLE_3

What I am getting:

Code:

TABLE_1,TABLE_2,TABLE_3,

I want to avoid that last comma after TABLE_3 which is coming since there is a newline character at the end of the file. I am not sure whether the file will always have that newline char at the end of file so I need to be sure it doesnt blindly trims the last char but removes it only if it is a comma.

Can you please suggest a solution for this?

Regards,
Newbie

try:

Code:

awk '$1=$1' RS= OFS=, infile

Using sed,

Code:

sed ':a;N;$!ba;s/\n/,/g'

Code:

sed -n -e '1h;1!H;${x;s/\n/,/g;p;}' parameter.rtf

Solution from the previous post seems elegant; Unix sed needs

Code:

sed -e ':a' -e 'N;$!ba' -e 's/\n/,/g'

A simple solution using paste:

Code:

$ paste -sd, file
TABLE_1,TABLE_2,TABLE_3

Thanks a lot guys. It helped!!!

Now an addition to it:
TABLE_1
TABLE_2
TABLE_3
are transposed as TABLE_1,TABLE_2,TABLE_3

Now I need it as 'TABLE_1','TABLE_2','TABLE_3'
Again to make sure the last character is not a comma.

Appreciate your support.

Cheers,
NG

Try

Code:

$ cat file
TABLE_1
TABLE_2
TABLE_3

Code:

$ awk '{x=(NR==1)?"\x27"$0"\x27":x OFS "\x27"$0"\x27"}END{print x}' OFS=, file

Resulting

Code:

'TABLE_1','TABLE_2','TABLE_3'