hwo do I print ' in an awk statment?

baraka · #1 (**permalink**) 11-30-2006

hi 2 all,
I'm trying 2 print " ' " in an awk statement but the sign deosn't show.
The only way I came with is 2 declare the ' as a variable and call that variable.
I'm trying 2 do:
awk '{printf("insert into ba_memo_01 values ('%s');",$1)}'

and get the output:
insert into ba_memo_01 values ('627562');

thanks

baraka · #2 (**permalink**) 11-30-2006

hi 2 all,
I'm trying 2 print " ' " in an awk statement but the sign deosn't show.
The only way I came with is 2 declare the ' as a variable and call that variable.
I'm trying 2 do:
awk '{printf("insert into ba_memo_01 values ('%s');",$1)}'

and get the output:
insert into ba_memo_01 values ('627562');

thanks

ask.jackal · #3 (**permalink**) 11-30-2006

awk '{print "insert into ba_memo_01 values('627562');"}'

works good for me

John

baraka · #4 (**permalink**) 11-30-2006

it doesn't work it prints:
insert into ba_memo_01 values(627562);
withuot the '

Ygor · #5 (**permalink**) 11-30-2006

Try...

Code:

awk '{printf("insert into ba_memo_01 values (\047%s\047);",$1)}'

baraka · #6 (**permalink**) 11-30-2006

thanks it worked beautifully

matrixmadhan · #7 (**permalink**) 11-30-2006

Just a round about way,

modify the source file to hold quotes,
123 -> '123'

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
How to redirect value from sql select statment to unix variable	abdulhafeez	Shell Programming and Scripting	17	10-22-2008 12:55 AM
if statment, based on retune value	toliver182	Shell Programming and Scripting	1	05-16-2008 08:51 AM
Imitating DOS functionality: The Call Statment	jadionne	UNIX for Dummies Questions & Answers	21	12-25-2007 12:01 PM
what is wrong with my awk statment?	hankooknara	Shell Programming and Scripting	1	06-18-2007 11:27 PM
problem w/ -z && -n switches in an if statment	Optimus_P	Shell Programming and Scripting	1	07-31-2002 10:22 AM

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode	Rate This Thread:


	Powered by