How to convert column in one line and also add ' and ,

[netbackup1234]

Hi
I have column like this
CARBON
CBDSWTS08
CBDSAPPNUS01
CBDSWTS09
CBDSWTS1
CCURE_HOST

And i want output like following
('CARBON','CBDSWTS08','CBDSAPPNUS01','CBDSWTS09','CBDSWTS1','CCURE_HOST')

How do i achive this with awk ?

 

[feherke]

Hi

awk -vq="'" 'BEGIN{printf"("}{printf(NR>1?",":"")q$0q}END{print")"}' /input/file

Tested with [tt]gawk[/tt] and [tt]mawk[/tt].

Feherke.

http://rootshell.be/~feherke/

 

[netbackup1234]

Hi
Feherke

I am new to awk. Would you explain each pieces in above awk program ?

Your help apprciated.

 

[Annihilannic]

# run awk and set the value of variable q to "'"
awk -vq="'" '
    # before processing any input, print a "("
    BEGIN{ printf"(" }
    # for each line of input if the current record number
    # is greater than 1, print a ",", otherwise nothing,
    # followed by the contents of variable q, the current
    # line, and then the contents of variable q again
    {printf(NR>1?",":"")q$0q}
    # when all input processed, print a ")"
    END{print")"}
' /input/file

Annihilannic.

 

[netbackup1234]

Hi
Annihilannic

i am still confuse following ( NR>1?",":"")
If NR greater than 1 then put "," then what is role of ":" ?

 

[vgersh99]

( NR>1?",":"")

in plain-English: if 'NR>1', return ","
otherwise return ""

vlad
+----------------------------+
| #include<disclaimer.h> |
+----------------------------+

 

[netbackup1234]

Hi..
VGERSH99
Thank you for your answere.