bailong360

@echo off
<%0 more +4 >$.awk
gawk -f $.awk a.txt
del $.awk&exit
BEGIN {FS=","}
{
    if (data[$1","$2","$3","$4","$5]==0) 
        data[$1","$2","$3","$4","$5]=$6
     else 
        data[$1","$2","$3","$4","$5]=$6>data[$1","$2","$3","$4","$5]?$6:data[$1","$2","$3","$4","$5]
    
}
END {
    for (line in data)
        printf("%s,%d\n",line,data[line])>"$new.txt"
}
复制代码

拙作,楼下既然有更好的代码了,就放在这里当作纪念吧

bailong360

回复 5# CrLf


    我原先也是这样的,后来发现输出以后没有逗号,所以改成了这个样子

看了下兄弟楼下的代码,感叹自己的思路实在是僵硬啊..