topic Re: awk statement in Operating System - Linux

awk statement

Sandeepk_1 — Thu, 08 Mar 2007 07:48:40 GMT

can anyone validate this syntax and let know whether the output will be a desired one?
cat $filename | grep $UNO| awk -v reg=$region -v cir=$circle -v uno=$UNO '$18 > 90 && $3==uno {print reg"\t"cir" \t "$3" \t " $4"-"$5"-"$6" \t "$18 "\t"}'

Re: awk statement

Court Campbell — Thu, 08 Mar 2007 08:19:57 GMT

This makes no sense. We should not be the ones determining the desired output. Plus we do not know what is in the file that is being cat'ed, nor what the value of $UNO is, etc. How could we possibly answer this?

Re: awk statement

Stuart Browne — Thu, 08 Mar 2007 17:28:23 GMT

in any case, learn how to use a printf() statement.

Re: awk statement

Sandeepk_1 — Fri, 09 Mar 2007 01:00:30 GMT

Thanks Court for an interesting reply!!! I would prefer if you would once again read my question carefully.
Thanks Stuart for the generous reply, I will definitely check out and learn.

Re: awk statement

Hein van den Heuvel — Sat, 10 Mar 2007 18:08:18 GMT

Sandeep,

Please re-read your own question carefully and now judge how anyone can possibly answer it?!

How can anyone know what 'desired' output is without specifying some details on both input and output format.

The suggested command might do something useful is the file pointed to by $filename is a file with white-space seperated columns where some lines contain $UNO in some 3rd columns. Some of those lines would need to have 18 or more columns and the value in column 18 should be larger than 90 for more that 1 of those.

But here is some free advide anyway!
Get rid of the 'cat' and the 'grep'!
Just let awk do the work!

awk -v... '$3==uno $18>90 {...}' $filename

Finally... have you simply tried it?
Just make a mock-up file with some valid lines and some bad lines.

Kindest regards,
Hein van den Heuvel.

Re: awk statement

Hein van den Heuvel — Sat, 10 Mar 2007 23:01:54 GMT

Oh, btw, you seem to want to make a Tab-Seperated-Values output file (easy for Excel).
The easiest way to do that in awk is to set the Output Field Seperator (OFS) to tab.

awk -v... 'BEGIN {OFS="\t"} $3==uno... {print reg,cir,$3,...}'

Hein.

Re: awk statement

Sandeepk_1 — Mon, 12 Mar 2007 04:29:26 GMT

Thanks alot everyone for your support. got the exact syntax done.

Re: awk statement

Sandeepk_1 — Mon, 12 Mar 2007 04:31:09 GMT

thanks once again