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$$
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$$
本文介绍了一段Shell脚本,该脚本用于从文件中筛选特定格式的数据,并对其进行统计汇总。通过使用awk和sort等命令,实现了对数据的高效处理。此外,脚本还提供了总计计算功能。
755

被折叠的 条评论
为什么被折叠?



