[SOLVED] Awk command help

Guilty1682 · 02-21-2011, 05:45 PM

Hi guys,
I'm having a little of trouble with awk.
Assuming I have a table or layout as the following:

Environment OS Version
AAA, BBB 9.0, CCC x87h
CCC, DDD 7.1, HHH g35p
AAA, BBB 6.1, CCC x87h
AAA, BBB 9.0, CCC x87h
CCC, DDD 2.1, HHH z93y
AAA, BBB 9.0, CCC x87h
AAA, BBB 9.0, CCC r61v
AAA, BBB 9.0, CCC k90s

I want to have an output that will display only Environment that CONTAINS BBB 9.0
and CCC x87h

How do I do that? Should I use grep in this situation?

Thanks!

Tinkster · 02-21-2011, 05:52 PM

Hi, welcome to LQ!

If position of the match is relevant awk is a good choice:

Code:

awk '$2 ~ /BBB 9.0/ || $3 ~ /CCC x87h/' file

Cheers,
Tink

trist007 · 02-21-2011, 05:53 PM

I'm a bit rusty but something like this in an awk script.

BEGIN {}
if(( $2 ~ /BBB/ ) && ( $3 ~ /9\.0/)) {
print $0;
}
END{}

Then you would cat file | awk -f script.awk

Guilty1682 · 02-21-2011, 06:04 PM

Thanks both you!!

However, it did not work for me, I was using this command --> awk '$2 ~ /BBB 9.0/ || $3 ~ /CCC x87h/' file
after I typed mine up, it did not have any output. Basically, nothing happens.
I'm pretty sure it's something I did xD
But, do you mind explain to me about your command? like break it down a bit? So, I can have a clear understanding of it?

Thanks!

P.S. I just saw my original post, the format is messed up. The envionment, OS, Version are the title and below them are the layout,
they are also separated by "," to match up with the title.

Tinkster · 02-21-2011, 06:24 PM

My bad ... I forgot one crucial bit:

Code:

awk -F, '$2 ~ /BBB 9.0/ || $3 ~ /CCC x87h/' file

trist007 · 02-21-2011, 06:26 PM

Try this.

Code:

BEGIN{}
{
if(/BBB 9\.0/ && /CCC x87h/)
          print $0;
}
END{}

or ultra thin version

Code:

{
if(/BBB 9\.0/ && /CCC x87h/)
          print $0;
}

Then do

Code:

cat data_filename | awk -f this_script.awk

Guilty1682 · 02-21-2011, 06:52 PM

Sweet! Thanks guys! both methods worked like a charm!
I have some output now.

However, as for the
awk -F, '$2 ~ /BBB 9.0/ || $3 ~ /CCC x87h/' file

There are some other output got mixed up with "good" display.
Ex.
AAA1, BBB 9.0, CCC x87h
AAA2, BBB 9.0, CCC x87h
AAA3, BBB 9.0, CCC x87h
AAA4, BBB 5.6, CCC x87h
AAA5, BBB 9.0, CCC v73k

Any idea why is it like that?

Thank you so much!

Also, I totally agree with you for I'll rather attempt to aid you in helping yourself than
giving you a "turn-key solution"

I did some research and right now I have a pretty good understand of what you did.

trist007 · 02-21-2011, 06:57 PM

Should be

Code:

awk -F, '$2 ~ /BBB 9.0/ && $3 ~ /CCC x87h/' file

Guilty1682 · 02-21-2011, 07:00 PM

@Trist007
Thank you! that worked perfectly, what's the difference between // and &&? I look through the websites around a bit, my only conclusion is that they both serve as "AND" if I'm not mistaken.

If I'm wrong, please point me to the right direction.

Thanks again both of you, it was great help!!

grail · 02-21-2011, 07:30 PM

It is not a comparison between // and && but rather || and &&.

|| - OR
&& - AND

Guilty1682 · 02-21-2011, 08:24 PM

Ah, I see,
thanks guys!