文本过滤并排行
过滤文本得到数据的排行。文本如下: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"
awk -F[:,] '{a[$7":"$8]++}END{PROCINFO["sorted_in"]="@val_num_desc";for(i in a) print a,i}' file 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 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 有点乱套啊。不清晰。
页:
[1]