how to escape ' in awk 3

[bishop7]

Can someone please tell me how to escape ' in the printf of an awk script.

Here is an example
nawk '{printf("exec dbms_system.SET_BOOL_PARAM_IN_SESSION(%s,%s,\'\n",$1,$2)}' $tracefile >xx

it's the first ' right before the \n" that's blowing up.

Thanks

 

[vgersh99]

nawk '{printf("exec dbms_system.SET_BOOL_PARAM_IN_SESSION(%s,%s,%c\n",$1,$2, 39)}' $tracefile >xx

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

 

[PHV]

Try something like this:
nawk '{printf(&quot;exec dbms_system.SET_BOOL_PARAM_IN_SESSION(%s,%s,'&quot;'&quot;'\n&quot;,$1,$2)}' $tracefile >xx

Hope This Help
PH.

 

[Ygor]

Or use the octal number of the ascii character...
[tt]
printf &quot;\047\n&quot;