论坛徽章:: 8

电梯直达

1楼 [收藏(0)] [报告]

发表于 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

稍有积蓄

论坛徽章:: 0

2楼 [报告]

发表于 2020-07-24 23:10 |只看该作者

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

复制代码

实战分享：从技术角度谈机器学习入门| 【大话IT】RadonDB低门槛向MySQL集群下战书 | ChinaUnix打赏功能已上线！ | 新一代分布式关系型数据库RadonDB知多少？

ll104567

家境小康

论坛徽章:: 10

3楼 [报告]

发表于 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

实战分享：从技术角度谈机器学习入门| 【大话IT】RadonDB低门槛向MySQL集群下战书 | ChinaUnix打赏功能已上线！ | 新一代分布式关系型数据库RadonDB知多少？

ll104567

家境小康

论坛徽章:: 10

4楼 [报告]

发表于 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