awk 對滿足條件的行求和

轉自：

http://bbs.chinaunix.net/thread-1842094-1-1.html

$ cat urfile

    序号,機構号,金額,姓名,客戶号,五級

    1,5416,350000,熊清喜,48260000140870,次級

    2,5416,50000,楊小平,48260000142862,次級

    3,5416,4500,楊明成,48260000144168,次級

    4,5417,7000,蒲猛,48260000144266,次級

    5,5418,10000,楊小平,48260000142862,可疑

    6,5417,5000,張瑞東,48260000145752,可疑

    7,5417,500000,楊明成,48260000144168,可疑

    8,5419,200000,張瑞東,48260000145752,損失

    9,5417,25000,楊小平,48260000142862,正常

    10,5417,15000,蒲猛,48260000144266,正常

$ awk 'BEGIN{FS=OFS=","}NR==FNR{a[$5]+=$3;next}{if(FNR>1)$NF=a[$5]","$NF}1' urfile urfile

    序号,機構号,金額,姓名,客戶号,五級

    1,5416,350000,熊清喜,48260000140870,350000,次級

    2,5416,50000,楊小平,48260000142862,85000,次級

    3,5416,4500,楊明成,48260000144168,504500,次級

    4,5417,7000,蒲猛,48260000144266,22000,次級

    5,5418,10000,楊小平,48260000142862,85000,可疑

    6,5417,5000,張瑞東,48260000145752,205000,可疑

    7,5417,500000,楊明成,48260000144168,504500,可疑

    8,5419,200000,張瑞東,48260000145752,205000,損失

    9,5417,25000,楊小平,48260000142862,85000,正常

    10,5417,15000,蒲猛,48260000144266,22000,正常

轉載于:https://blog.51cto.com/3404903/981789