simple quote in awk print 1

[loloman]

Hy,
I want to display this
select ID from table where IDCOMMANDE = '123';
with awk
my command is :

grep "COMMANDE" $FILE | awk -F";" '{ print "select ID from table where IDCOMMANDE = "$8";"}'

this command display that
select * from table where ID = 123;

how can i display select ID from table where IDCOMMANDE = '123';

thank you

 

[feherke]

Hi

My preferred way :

grep "COMMANDE" $FILE | awk -F";" [red]-vq="'"[/red] '{ print "select ID from table where IDCOMMANDE = " [red]q[/red] $8 [red]q[/red] ";"}'

Or you can mess with changing or interrupting the quotes.

Feherke.

http://rootshell.be/~feherke/

 

[feherke]

Hi

To show the other alternatives I mentioned :

grep "COMMANDE" $FILE | awk -F";" [red]"[/red]{ print [red]\[/red]"select ID from table where IDCOMMANDE = [red]'\[/red]"$8[red]\[/red]"[red]'[/red];[red]\[/red]"}[red]"[/red]

[gray]# or[/gray]

grep "COMMANDE" $FILE | awk -F";" '{ print "select ID from table where IDCOMMANDE = "[red]'"'"'[/red]$8[red]'"'"'[/red]";"}'

Feherke.

http://rootshell.be/~feherke/

 

[PHV]

awk -F';' "/COMMANDE/{print \"select ID from table where IDCOMMANDE = '\"\$8\"';\"}" $FILE

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886