Column sum group by uniq records - Page 2

ranjithpr · #1 (**permalink**) 02-16-2009

Try this

Code:

awk -F  ";"  '{ string=$1 ";" $2; arr[string] += $3 } END {for (i in arr) {print i ";" arr[i] } }' inputfile

sandeep13 · #2 (**permalink**) 02-16-2009

This one also doesn't work....

Franklin52 · #3 (**permalink**) 02-16-2009

What doesn't work? Did you get errors, wrong output, no output? Try this:

Code:

awk 'BEGIN{FS=OFS=";"}
NR==1{print;next}
{a[$1";"$2]+=$3}
END{for(i in a)print i, a[i]}' file

Use nawk or /usr/xpg4/bin/awk on Solaris.

Regards

sandeep13 · #4 (**permalink**) 02-16-2009

Hi Franklin,

I tried ur solution and getting below o/p

PORT;PID;TOTAL
port1;p1
port2;p2

I guess someting is missing, it is doing group by but missing the output values.
Thanks for the response.

Regards,
Sandeep

sandeep13 · #5 (**permalink**) 02-16-2009

getting below o/p..missed some values in last post

PORT;PID;TOTAL
port1;p1;500
port2;p2;0

Quote:

Originally Posted by sandeep13

Hi Franklin,

I tried ur solution and getting below o/p

PORT;PID;TOTAL
port1;p1
port2;p2

I guess someting is missing, it is doing group by but missing the output values.
Thanks for the response.

Regards,
Sandeep

Franklin52 · #6 (**permalink**) 02-16-2009

This is what I get:

Code:

$ cat file
PORT; ID; TOTAL
port1;p1;100000
port2;p2;5000
port1;p1;500
$
$
$ awk 'BEGIN{FS=OFS=";"}                              
NR==1{print;next}
{a[$1";"$2]+=$3}
END{for(i in a)print i, a[i]}' file
PORT; ID; TOTAL
port2;p2;5000
port1;p1;100500
$
$

Regards

sandeep13 · #7 (**permalink**) 02-16-2009

HI Franklin,

Thanks a lot. It works....using nawk

/usr/bin/nawk 'BEGIN{FS=OFS=";"}NR==1{print;next}{a[$1";"$2]+=$3}END{for(i in a)print i, a[i]}' file

Much appreciated.

Cheers,
Sandeep

Quote:

Originally Posted by Franklin52

This is what I get:

Code:

$ cat file
PORT; ID; TOTAL
port1;p1;100000
port2;p2;5000
port1;p1;500
$
$
$ awk 'BEGIN{FS=OFS=&quot;;&quot;}                              
NR==1{print;next}
{a[$1&quot;;&quot;$2]+=$3}
END{for(i in a)print i, a[i]}' file
PORT; ID; TOTAL
port2;p2;5000
port1;p1;100500
$
$

Regards

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
Monkcast #12: IBM HW group OEMs Solaris to chagrin of SW group & a ... - ZDNet.com bl	iBot	UNIX and Linux RSS News	0	08-17-2007 04:30 PM
Count No of Records in File without counting Header and Trailer Records	guiguy	Shell Programming and Scripting	2	06-07-2007 12:15 PM
find and group records in a file	thumsup9	UNIX for Advanced & Expert Users	20	04-19-2007 05:04 PM
Select records based on search criteria on first column	shashi_kiran_v	UNIX for Dummies Questions & Answers	2	12-02-2005 01:49 PM
entry in /etc/group too long - problem using sudo with %group	poli	SUN Solaris	4	12-21-2004 09:50 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: