group lines

[aasislopez]

Dear all,

I wonder how awk can order by group (first colum) and show only group(s) if all lines of the group have NOK as second field.

Input:
AND OK
AND NOK
AND NOK
VAL OK
VAL OK
VAL OK
MAD NOK
MAD NOK
MAD NOK

Output:
MAD NOK
MAD NOK
MAD NOK

Many thanks,

 

[Cybex1]

Your sample output doesn't match your stated requirements. By your own sample data, your output for all "NOK" in the second field should be:

AND NOK
AND NOK
MAD NOK
MAD NOK
MAD NOK

So, if this is truly the out put you desire...

root@linux:~# cat sort.txt | awk '$2 == "NOK"'
AND NOK
AND NOK
MAD NOK
MAD NOK
MAD NOK