zl624867243 发表于 2020-07-24 14:09

文本过滤并排行

过滤文本得到数据的排行。文本如下:
res_data:{"code":0,"data":[{"archivesSn":"20191119210001160773","custPhone":"11111111","custIdNum":"22222","custName":"曹xx","vehicleModelName":"奔驰"}],"firstPage":true,"}
res_data:{"code":0,"data":[{"archivesSn":"20201119210001160773","custPhone":"11111111","custIdNum":"333","custName":"周xx","vehicleModelName":"宝马"}],"firstPage":true,"}
res_data:{"code":0,"data":[{"archivesSn":"20201119210001160773","custPhone":"11111111","custIdNum":"22222","custName":"谢xx","vehicleModelName":"奔驰"}],"firstPage":true,"}其中:
custIdNum:**号
custName:   名字
custPhone:手机号


想要的结果,想得到**的排行的数据
2 "custPhone":"11111111"
1 "custPhone":"2222"

jzsjm1002 发表于 2020-07-24 23:10

awk -F[:,] '{a[$7":"$8]++}END{PROCINFO["sorted_in"]="@val_num_desc";for(i in a) print a,i}' file

ll104567 发表于 2020-07-26 18:48

root@aliyun:~/lp/regex# cat tmp
res_data:{"code":0,"data":[{"archivesSn":"20191119210001160773","custPhone":"11111111","custIdNum":"22222","custName":"曹xx","vehicleModelName":"奔驰"}],"firstPage":true,"}
res_data:{"code":0,"data":[{"archivesSn":"20201119210001160773","custPhone":"11111111","custIdNum":"333","custName":"周xx","vehicleModelName":"宝马"}],"firstPage":true,"}
res_data:{"code":0,"data":[{"archivesSn":"20201119210001160773","custPhone":"11111111","custIdNum":"22222","custName":"谢xx","vehicleModelName":"奔驰"}],"firstPage":true,"}
root@aliyun:~/lp/regex# cat tmp|grep -P '(?:"custPhone":")([^"]+)","custIdNum":"([^"]+)"' -o
"custPhone":"11111111","custIdNum":"22222"
"custPhone":"11111111","custIdNum":"333"
"custPhone":"11111111","custIdNum":"22222"
root@aliyun:~/lp/regex# cat tmp|grep -P '(?:"custPhone":")([^"]+)","custIdNum":"([^"]+)"' -o |awk -F '[":]+' '{print $(NF-1),"custPhone",$3}'
22222 custPhone 11111111
333 custPhone 11111111
22222 custPhone 11111111
root@aliyun:~/lp/regex# cat tmp|grep -P '(?:"custPhone":")([^"]+)","custIdNum":"([^"]+)"' -o |awk -F '[":]+' '{print $(NF-1),"custPhone",$3}'|sort -nk 1
333 custPhone 11111111
22222 custPhone 11111111
22222 custPhone 11111111

ll104567 发表于 2020-07-26 18:50

root@aliyun:~/lp/regex# cat tmp
res_data:{"code":0,"data":[{"archivesSn":"20191119210001160773","custPhone":"11111111","custIdNum":"22222","custName":"曹xx","vehicleModelName":"奔驰"}],"firstPage":true,"}
res_data:{"code":0,"data":[{"archivesSn":"20201119210001160773","custPhone":"11111111","custIdNum":"333","custName":"周xx","vehicleModelName":"宝马"}],"firstPage":true,"}
res_data:{"code":0,"data":[{"archivesSn":"20201119210001160773","custPhone":"11111111","custIdNum":"22222","custName":"谢xx","vehicleModelName":"奔驰"}],"firstPage":true,"}
root@aliyun:~/lp/regex# cat tmp|grep -P '(?:"custPhone":")([^"]+)","custIdNum":"([^"]+)"' -o
"custPhone":"11111111","custIdNum":"22222"
"custPhone":"11111111","custIdNum":"333"
"custPhone":"11111111","custIdNum":"22222"
root@aliyun:~/lp/regex# cat tmp|grep -P '(?:"custPhone":")([^"]+)","custIdNum":"([^"]+)"' -o |awk -F '[":]+' '{print $(NF-1),"custPhone",$3}'
22222 custPhone 11111111
333 custPhone 11111111
22222 custPhone 11111111
root@aliyun:~/lp/regex# cat tmp|grep -P '(?:"custPhone":")([^"]+)","custIdNum":"([^"]+)"' -o |awk -F '[":]+' '{print $(NF-1),"custPhone",$3}'|sort -nk 1
333 custPhone 11111111
22222 custPhone 11111111
22222 custPhone 11111111

renxiao2003 发表于 2020-10-28 21:45

有点乱套啊。不清晰。
页: [1]
查看完整版本: 文本过滤并排行