Hi,

i have many lines (each line will have a number) in a text file as below:

111
222
333

and i need to format it as below

'111',
'222',
'333');

Please note that there is no comma (,) after last entry but closed with );

I guess it can be done using awk but could not succeed. Please advise.

TIA
Prvn

What have you tried so far and where exactly are you stuck?

/usr/local/bin/awk -v x="'" '{ s=s sprintf(x "%s" x "," "\n", $0) } END { sub(",$", "", s); print(s) }' <file>

gives me the below output:

'111',
'222',
'333',


Not able to get the last "," removed.

Here try this:
cat file.txt|wc -l| awk '{$1=$1-1;system("head -"$1" file.txt")}'| awk '{printf("%c%s%c\n",39,$1,39)}'; tail -1 file.txt | awk '{printf("%c%s%c);",39,$1,39)}'

Wow, let's see:
The Useless Use Of cat, wc, awk, head, tail Award
Only sed and the job is done:
Regards,

i'm still learning too, thx for the tip, don't need to be rude though.

Thanks Danmero, NYankz and Marcus,

All your solutions worked.


Prvn