quotes using awk

Shell Programming and Scripting
1

i want to print the statement below using awk,but i am unable to get the quotes

("22345",1,"Thank you");

How can i do this

2 
BEGIN {
   qq=sprintf("%c", 034)
}
{
......
   printf("(%c22345%c,1,%cThank you%c);", qq, qq,qq,qq) 
}
3 
awk 'BEGIN{print "(\"22345\",1,\"Thank you\")" ; exit}'

:):):slight_smile:

4

Hi,

Try this...

awk 'BEGIN {print "(\42""22345\42,1,\42thank you\42)"}'
5

it worked. thank you

---------- Post updated at 01:10 PM ---------- Previous update was at 01:05 PM ----------

I have a files containing varying contents like
file a has content

2334|abc
2335|asd
2336|wer
2345|wdf

file b has content

1234|dfg
1235|fgh
1236|ghj
1235|fgj
1237|vbn
1278|wdh

i want an awk scripts to write this statement
select * from table where number in (2334,2335,2336,2345)

i want the script to determine the total number of lines and then put the variable line in the statement,for this files its variable 1($1)

6

if your question has been answered, don't piggy-back new questions on top of the old threads - start a new thread instead. Thank you.
I'm closing thee thread!