Replace end of line with comma and put parenthesis in sed/awk

Question

I am trying to process the contents of a file from this format:

this1,EUR 
that2,USD
other3,GBP

to this format:

this1(EUR),that2(USD),other3(GBP)

The result should be a single line.

As of now I have come up with this circuit of commands that works fine:

cat myfile | sed -e 's/,/\(/g' | sed -e 's/$/\)/g' | tr '\n' , | awk '{print substr($0, 0, length($0)- 1)}'

Is there a simpler way to do the same by just an awk command?

Answer 1

Another awk:

$ awk -F, '{ printf "%s%s(%s)", c, $1, $2; c = ","} END { print ""}' file

1(EUR),2(USD),3(GBP)

Answer 2

Following awk may help you on same.

awk -F, '{val=val?val OFS $1"("$2")":$1"("$2")"} END{print val}' OFS=,  Input_file