awk 归类汇总
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$$
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$$