Count first column on the basis of two other columns

kaustubh137 · #1 (**permalink**) 05-29-2008

Hello,

I have a file
=================
12 SRV1 GRP1
19 SRV1 GRP1
19 SRV1 GRP2
3 SRV1 GRP1
3 SRV1 GRP2
30 SRV1 GRP2
7 SRV1 GRP1
8 SRV1 GRP3
===========

I want output like
===============
41 SRV1 GRP1
52 SRV1 GRP2
8 SRV1 GRP3

Basically I want to calculate the count of first column based on other 2 columns.

Thanks in advance.

aigles · #2 (**permalink**) 05-29-2008

Something like that ?

Code:

awk '
{ sum[$2 OFS $3] += $1 }
END { for (f in sum) print sum[f],f }
' inputfile > outputfile

Jean-Pierre.

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
Convert two column data into 8 columns	NickC	Shell Programming and Scripting	8	06-28-2008 12:19 PM
Single column to multiple columns in awk	astroDave	Shell Programming and Scripting	2	03-27-2008 10:00 PM
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
single column to multiple columns	agibbs	UNIX for Dummies Questions & Answers	7	12-05-2007 10:04 PM
Print last 4 columns (variable column #)	Da_Duck	UNIX for Dummies Questions & Answers	19	02-27-2004 10:33 AM

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