如何求awk 数组中的最大值？

lightning

我通过 awk -F \| '{b[$1 OFS $5 OFS $6]=(a[$1 OFS $5 OFS $6]+=$7)/300}END{for(i in b)print i,b}' ss.txt
得出

2012:04:08 08:30:00 sendSms 26 134.707
2012:04:08 09:00:00 notifyMessageDeliveryReceipt 29 0.86
2012:04:08 01:40:00 smsDeliveryConfirm 26 12.3967
2012:04:12 00:05:00 notifySmsDeliveryReceipt 26 41.38
2012:04:07 21:45:00 notifyMessageReception 27 0.0133333
2012:04:11 14:10:00 sendMessage 27 1.57
2012:04:12 22:50:00 notifyMessageDeliveryReceipt 27 0.156667
2012:04:12 08:20:00 notifySmsReception 26 30.21
2012:04:11 16:50:00 sendMessage 29 0.703333
2012:04:11 14:10:00 sendMessage 29 2.65667
2012:04:12 22:50:00 notifyMessageDeliveryReceipt 29 0.353333
2012:04:10 14:00:00 notifySmsDeliveryReceipt 26 239.407
2012:04:10 16:20:00 notifyMessageDeliveryReceipt 27 3.47333

其中 '2012:04:08 08:30:00' == $1  'sendSms' ==$5  26==$6 , 后面的134.707 为数值，我想算出 2012:04:08 sendSms 26 的最大值是多少，即 4月8日当天的最大值时多少，以此类推，其他的类型在其他日期的当天最大值时多少？
请问如何该如何写这个判断

补充原始文件格式

2012:04:07 12:55:00|2012:04:07 13:00:00|193501|192300|sendSms|26|147|147|0||20562
2012:04:07 12:55:00|2012:04:07 13:00:00|190501|193501|notifySmsDeliveryReceipt|26|268|268|0||53443
2012:04:07 12:55:00|2012:04:07 13:00:00|191101|193501|notifySmsDeliveryReceipt|26|162|162|0||31915
2012:04:07 12:55:00|2012:04:07 13:00:00|192800|193501|notifySmsDeliveryReceipt|26|89|89|0||17537
2012:04:07 12:55:00|2012:04:07 13:00:00|193501|192101|sendSms|26|85|85|0||23171
2012:04:07 12:55:00|2012:04:07 13:00:00|193501|190901|sendSms|26|76|76|0||23165
2012:04:07 12:55:00|2012:04:07 13:00:00|193501|191101|sendSms|26|153|153|0||33495
2012:04:07 12:55:00|2012:04:07 13:00:00|193501|190501|sendSms|26|270|270|0||41783
2012:04:07 12:55:00|2012:04:07 13:00:00|193501|190600|sendSms|26|51|51|0||12073
2012:04:07 12:55:00|2012:04:07 13:00:00|193501|191200|sendSms|26|222|222|0||17516
2012:04:07 12:55:00|2012:04:07 13:00:00|193501|191001|sendSms|26|55|55|0||18461
2012:04:07 12:55:00|2012:04:07 13:00:00|193501|193001|sendSms|26|10|10|0||2971
2012:04:07 12:55:00|2012:04:07 13:00:00|193501|192401|sendSms|26|22|22|0||6023
2012:04:07 12:55:00|2012:04:07 13:00:00|193501|191801|sendSms|26|84|84|0||19990
2012:04:07 12:55:00|2012:04:07 13:00:00|190600|193501|notifySmsReception|26|2|2|0||413
2012:04:07 12:55:00|2012:04:07 13:00:00|191200|193501|notifySmsReception|26|56|56|0||10788

jiejie455

1. awk -vFS="[| ]" '/sendSms/{a[$1" "$7" "$8]=($13>a[$1" "$7" "$8])?$13:a[$1" "$7" "$8]}END{for(i in a){print i"\t"a[i]}}' data

复制代码

lightning

已经自己解决，谢谢各位了

jenny815

楼主怎么解决的啊，纯脚本怎么写？

ziyunfei

1. function max(arr, m, i) {
   
2.         m = arr[0];
   
3.         for (i in arr) {
   
4.                 if (arr[i] > m) {
   
5.                         m = arr[i];
   
6.                 }
   
7.         }
   
8.         return m;
   
9. }
   
10. BEGIN {
    
11.         a[0] = 1;
    
12.         a[1] = 10;
    
13.         print max(a);
    
14. }

复制代码

dahaoshanhe

回复 3# lightning


    怎么解决的  贴上看看~~

lightning

不好意思，我刚看到短信信息，解决方法如下：

awk -F '[| ]' '{if(b[$1" "$7" "$8]<(a[$1" "$2" "$7" "$8]+=$9)/300)b[$1" "$7" "$8]=(a[$1" "$7" "$8]+=$9)/300}END{for(i in b)printf "%s\t%s\n", i,b[i]}' ss.txt

lightning

dahaoshanhe 发表于 2012-07-10 15:44
回复 3# lightning

awk -F \| '{if(b[$1" "$7" "$8]<(a[$1" "$2" "$7" "$8]+=$9)/300)b[$1" "$7" "$8]=(a[$1" "$7" "$8]+=$9)/300}END{for(i in b)printf "%s\t%s\n", i,b}' ss.txt