awk 分类汇总

for i in $(sort -k6n -t'|'<file|cut -f6 -d'|'|sort -un);do
        echo "-------------------------------------------------------------------"
        awk 'BEGIN{FS=OFS="|"};$6~/\<'"$i"'\>/' file|tee tmp$$
        echo "-------------------------------------------------------------------"
        awk 'BEGIN{FS=OFS="|"}{sum[$6]+=$8}END{for(j in sum)print "Result:"sum[j]}' tmp$$

done
echo "-------------------------------------------------------------------"
awk -F\| '{sum+=$8}END{print "Total:"sum}' file
echo "-------------------------------------------------------------------"
rm tmp$$