How to get the count only if two column matches?

gobinath · #1 (**permalink**) 05-27-2008

Hi,

I have a file with the contents as below,

Code:

10:23:10        GOOD      10.30.50.60
10:23:11        GOOD      10.30.50.62
10:23:12        Hello        10.30.50.60
10:23:12        BAD         10.30.50.60
10:23:13        GOOD       10.30.50.66
10:23:14        BAD         10.30.50.62
10:23:15        Hello        10.30.50.66
10:23:16        Hello        10.30.50.66
10:23:16        BAD         10.30.50.66

jaduks · #2 (**permalink**) 05-27-2008

Code:

$ awk '$2=="Hello" {count["Number of "$2" for "$3]++}END{for(j in count) print j":",count[j]}' gobi1.txt
Number of Hello for 10.30.50.60: 1
Number of Hello for 10.30.50.66: 2

jaduks · #3 (**permalink**) 05-27-2008

And,

Code:

$ awk '$2=="Hello" {count["Number of "$2" for "substr($1,1,5)]++}END{for(j in count) print j"(time):",count[j]}' gobi1.txt
Number of Hello for 10:23(time): 3

Klashxx · #4 (**permalink**) 05-27-2008

Or:

Code:

awk '{a[$4 " in " $5]++
      b[$4" for "$1":"$2]++;next}
END{
for ( i in a )
   print "No of "i":" a[i]
print "---------------------------"
for ( i in b )
   print "No of "i"(time):" b[i]

}' FS="( )|(:)"file
No of GOOD in 10.30.50.60:1
No of GOOD in 10.30.50.62:1
No of GOOD in 10.30.50.66:1
No of BAD in 10.30.50.60:1
No of Hello in 10.30.50.60:1
No of BAD in 10.30.50.62:1
No of BAD in 10.30.50.66:1
No of Hello in 10.30.50.66:2
---------------------------
No of Hello for 10:23(time):3
No of BAD for 10:23(time):3
No of GOOD for 10:23(time):3

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
Count first column on the basis of two other columns	kaustubh137	Shell Programming and Scripting	1	05-29-2008 09:54 AM
How to check Null values in a file column by column if columns are Not NULLs	Mandab	Shell Programming and Scripting	7	03-15-2008 09:57 AM
How to count pattern in column	ahjiefreak	Shell Programming and Scripting	12	12-04-2007 07:53 PM
How to count the record count in an EBCDIC file.	oracle8	UNIX for Dummies Questions & Answers	1	07-26-2006 08:22 PM
Max column count in a file	gemini	Shell Programming and Scripting	2	08-24-2004 01:12 PM

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode	Rate This Thread:


	Powered by