How to get the count only if two column matches? - Shell Programming and Scripting

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

I need the output like this,

Code:

No of Hello for  10.30.50.60: 1
No of Hello for  10.30.50.66: 2

Also

Code:

No of Hello for 10:23 (time) : 3

Please anyone suggest a script for this.

Thanks in advance