awk statement

[Sandeepk_1]

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"}'

[Court Campbell]

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?

[Stuart Browne]

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

[Sandeepk_1]

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.

[Hein van den Heuvel]

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.

[Hein van den Heuvel]

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.

[Sandeepk_1]

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

[Sandeepk_1]

thanks once again