UNIX for Dummies Questions & Answers

I have a flat file that contains dynamic list of variables like
a=1
b=2
c=3
.
..
z=26

I need to convert the above into a csv file having the format below:
a,b,c,..,z
1,2,3,..,26

Please note, I do not want a comma separating the last variable.

I tried to refer the post 132268-how-create-csv-file-using-shell-script but it does not say how to create a header. (sorry I can't post it's url since I am limited in my ability to post url's as i don't have 5 posts on the forum)

Requesting your help.

Many Thanks,

Code:

awk -F'=' '{f1=f1?f1","$1:$1;f2=f2?f2","$2:$2}END{print f1; print f2}' file

Thanks a lot for the immediate response Sir yoda. May the force be with you.

I am new to unix shell scripting, can you please help explain the code a little bit.

The code uses a Conditional Expression to construct variables: f1 & f2 values

If f1 is defined, then append f1 value with comma , and first field $1 and assign to f1 else assign first field $1. Similarly for f2 but using second field $2.

In the END block, print variable values.

suppose that file content lies in a.txt

Code:

fld1=`awk -F'=' '{print $1}' a.txt|tr  '\n' ','|sed s/".$"//`
fld2=`awk -F'=' '{print $2}' a.txt|tr  '\n' ','|sed s/".$"//`
echo $fld1
echo $fld2