awk处理生产数据1--处理生产数据

样例数据：

 99841 Batches: user:Allen insert 3805 records into databases:product table:detail,insert 99800 records successfully,failed  41 records
 99842 Batches: user:Mike insert 32698 records into databases:product table:detail,insert 32000 records successfully,failed  698 records
 99843 Batches: user:Jerry insert 17675 records into databases:product table:detail,insert  records17600 successfully,failed  75 records
 99844 Batches: user:Tracy insert 3055 records into databases:product table:detail,insert  records 2055successfully,failed  1000 records

需求：统计每个人分别插入成功了多少条record，失败了多少条record

输出结果：user   success_record  failded_record

代码

BEGIN

{

prinf "%-10s%-20s%-10s/n","user","success_records","failed_record"

}

{

success[$4]+=$15

failed[$4]+=$18

}

END

{

for (u in success){

printf "%-10s%-20s%-10s/n",$u,success[$u],failed[$u]

}

}