hrm.. seems like you were missing a }
sort file | awk '{array[$1] += $2;} END { for (i in array) {print i "\t" array[i];}}'
regards,
Jason
On 10/25/2017 01:24 PM, m.roth@5-cent.us wrote:
Warren Young wrote:
On Oct 25, 2017, at 10:02 AM, Mark Haney mark.haney@neonova.net wrote:
I have a file with two columns 'email' and 'total' like this:
me@example.com 20 me@example.com 40 you@domain.com 100 you@domain.com 30
I need to get the total number of messages for each email address.
This screams out for associative arrays. (Also called hashes, dictionaries, maps, etc.)
That does limit you to CentOS 7+, or maybe 6+, as I recall. CentOS 5 is definitely out, as that ships Bash 3, which lacks this feature.
<snip> Associative arrays?
Awk! Awk! (No, I am not a seagull...)
sort file | awk '{ array[$1] += $2;} END { for (i in array) { print i "\t" array[i];}'
mark "associative arrays, how do I love thee? Let me tot the arrays..."
CentOS mailing list CentOS@centos.org https://lists.centos.org/mailman/listinfo/centos