[CentOS] [OT] Bash help

[Pete Biggs]

On Wed, 2017-10-25 at 12:02 -0400, Mark Haney wrote:
> I know this is for CentOS stuff, but I'm at a loss on how to build a 
> script that does what I need it to do.  It's probably really logically 
> simple, I'm just not seeing it.  Hopefully someone will take pity on me 
> and at least give me a big hint.
> 
> I have a file with two columns 'email' and 'total' like this:
> 
> me at example.com 20
> me at example.com 40
> you at domain.com 100
> you at domain.com 30
> 
> I need to get the total number of messages for each email address.  This 
> type of code has always been the hardest for me for whatever reason, and 
> honestly, I don't write many scripts these days. I'm struggling to get 
> psuedocode that works, much less a working script. I know this is off 
> topic, and if it gets modded out, that's fine.  I just can't wrap my 
> brain around it.
> 
Not bash but perl:

#####
#!/usr/bin/perl
my %dd;
while (<>) {
my @f=split;
$dd{$f[0]}{COUNT}+=$f[1];
}
print "\nSums:\n";
for (keys %dd) { print "$_\t $dd{$_}{COUNT}\n"; };
####

It takes the data on stdin, sums it into an associative array and
prints out the result

Results:
######
$ ./ppp
me at example.com 20
me at example.com 40
you at domain.com 100
you at domain.com 30

Sums:
you at domain.com	 130
me at example.com	 60
######

I'm sure some perl monk can come up with a single line command to do
the same thing.

P.