- 论坛徽章:
- 25
|
本帖最后由 wh7211 于 2018-12-11 19:09 编辑
回复 13# hsinxx
<<<awk4.0+
- cat 1
- 56055|10|1|11
- 56055|20|2|8
- 56055|30|3|5
- 56055|40|4|3
- 56055|50|5|1
- 56056|60|6|3
- 56057|70|7|1
- 56058|80|8|2
- 56058|90|9|2
- awk -F"|" '{++a;b[$1]+=$2;c[$1][a]=c[$1][a-1]+$3;d[$1][a]=$4;e[$1]=e[$1]>$4?e[$1]:$4;f[$1]=$0}END{for(i in c){if(length(c[i])>2){for(j in c[i]){for(k=1;k<=d[i][j]-d[i][j+1];k++){g[j]=g[j]?g[j]","c[i][j]:c[i][j]}};PROCINFO["sorted_in"]="@ind_num_desc";for(h in g){m[i]=m[i]?m[i]","g[h]:g[h]};print i"|"b[i]"|"m[i]"|"e[i]}else{print f[i]};delete g}}' 1
- 56055|150|15,10,10,6,6,3,3,3,1,1,1|11
- 56056|60|6|3
- 56057|70|7|1
- 56058|170|17,17|2
复制代码 |
|