Awk question: Sum dates - Shell Programming and Scripting

radoulov · #5 (**permalink**) 09-02-2008

Just guessing:
(use nawk or /usr/xpg4/bin/awk on Solaris)

Code:

awk 'END \
{ for (dt in third) print dt, second[dt], third[dt] }
{ if (!_[$1]++) third[$1] = $3; second[$1] += $2 }
' filename

If you need the output sorted, pipe it to sort (or use asorti if you have GNU Awk). Or just use Perl

Code:

perl -ane'
  $third{$F[0]} = $F[2] unless $x{$F[0]}++;
  $second{$F[0]} += $F[1];
  print map "$_ $second{$_} $third{$_}\n", sort keys %x
    if eof' filename