printing/escaping comma's in awk

[u856100]

peoples,

I have the following (myfile.txt) :

1234567
abcdefg
2354324
3242323
8798799

I want to change this to :

'1234567',
'abcdefg',
'2354324',
'3242323',
'8798799',

hence wrapping the content for use with a SQL query.

I have tried the following :

cat myfile.txt | awk '{print("\'"$0"\'")}' myfile.txt > newfile.txt

cat myfile.txt | awl 'print{("\'%s\',",$1)}' myfile.txt > newfile.txt

but I am not getting any joy!

any suggestions would be appreciated thanks

John

[John Palmer · Accepted solution]

John,

How about using sed instead...

sed -e s/^/\'/ -e s/$/\'/ myfile.txt > newfile.txt

Regards,
John

[monasingh_1]

you can also use awk -v var="'" and while printing use '{print var $1 var}'

do a man on awk...

hope this helps...

[T G Manikandan]

#vi /tmp/b
'1234567',
'abcdefg',
'2354324',
'3242323',
'8798799',


#cat /tmp/b|awk -F "'" '{print $2}'

[monasingh_1]

cat mytext.txt |awk -v var1="'" -v var2="," '{print var1 $1 var1 var2}' > newfile
should work...

[Robin Wakefield]

Hi John,

you can use a single sed command:

sed "s/.*/'&',/" myfile.txt

rgds, Robin

[Balaji N]

how abt this. here x27 is the ascii key for "'".

hth
-balaji


$ cat a.txt
1234567
abcdefg
2354324
3242323
8798799
$ awk '{printf "\x27%s\x127 \n",$1 }' a.txt
'1234567'
'abcdefg'
'2354324'
'3242323'
'8798799'