{"id":773,"date":"2010-08-12T14:33:48","date_gmt":"2010-08-12T19:33:48","guid":{"rendered":"http:\/\/appcrawler.com\/wordpress\/?p=773"},"modified":"2011-07-06T10:33:47","modified_gmt":"2011-07-06T15:33:47","slug":"using-awk-with-group-by-functionality","status":"publish","type":"post","link":"http:\/\/appcrawler.com\/wordpress\/2010\/08\/12\/using-awk-with-group-by-functionality\/","title":{"rendered":"Using awk with group by functionality"},"content":{"rendered":"<p>You can use the following example if you need to total numbers over a group in a given file.<\/p>\n<p>We first show our sample file&#8230;<\/p>\n<pre lang=\"text\" line=\"1\">\r\n14:30:57 oracle@emgrid01 ~ >cat list.txt\r\nsteve:61\r\nsteve:14\r\nbecky:57\r\nsteve:19\r\njenna:69\r\nstephen:57\r\nmaddie:54\r\njenna:53\r\nabby:41\r\njenna:21\r\njenna:66\r\njenna:64\r\nstephen:53\r\nstephen:26\r\njenna:77\r\nsteve:46\r\nmaddie:39\r\nsteve:32\r\nabby:77\r\njenna:97\r\n<\/pre>\n<p>&#8230;and then show the totals using awk&#8230;<\/p>\n<pre lang=\"text\" line=\"1\">\r\n14:30:59 oracle@emgrid01 ~ >awk -F \":\" '{a[$1]+=$2} END {for (i in a) {print i,a[i]}}' list.txt\r\nmaddie 93\r\nabby 118\r\njenna 447\r\nbecky 57\r\nsteve 172\r\nstephen 136\r\n14:31:01 oracle@emgrid01 ~ >\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>You can use the following example if you need to total numbers over a group in a given file. We first show our sample file&#8230; 14:30:57 oracle@emgrid01 ~ >cat list.txt steve:61 steve:14 becky:57 steve:19 jenna:69 stephen:57 maddie:54 jenna:53 abby:41 jenna:21&hellip;<\/p>\n<p class=\"more-link-p\"><a class=\"more-link\" href=\"http:\/\/appcrawler.com\/wordpress\/2010\/08\/12\/using-awk-with-group-by-functionality\/\">Read more &rarr;<\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_mi_skip_tracking":false,"footnotes":""},"categories":[28,27],"tags":[],"_links":{"self":[{"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/posts\/773"}],"collection":[{"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/comments?post=773"}],"version-history":[{"count":5,"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/posts\/773\/revisions"}],"predecessor-version":[{"id":972,"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/posts\/773\/revisions\/972"}],"wp:attachment":[{"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/media?parent=773"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/categories?post=773"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/tags?post=773"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}