awk 分組問題，請指教

whatislinux

有這樣一個日志文件，文件中 有errmsg，希望實現(xiàn)errmsg分類，并計算出現(xiàn)的次數(shù)，通過awk如何得到下面的輸入，請高手指教！
                  類別                                                             次數(shù)
"errmsg":"請先開通個人賬戶"                                               5次
"errmsg":"當(dāng)前>訂單狀態(tài)是已離店, 無法進(jìn)行申請返現(xiàn)操作"         8次
"errmsg":"請先>開通個人賬戶"                                            4次


{"ver":"1.0","ret":false,"errmsg":"請先開通個人賬戶","errcode":202,"data":"https://pay.ip-localhost/userAccount/account/my.htm","time":"2014-06-22 00:02:43"}
###200####{"ver":"1.0","ret":false,"errmsg":"當(dāng)前>訂單狀態(tài)是已離店, 無法進(jìn)行申請返現(xiàn)操作","errcode":404,"time":"2014-06-22 00:03:00"}####7EBA2C6B-BAD7-4714-B
00####{"ver":"1.0","ret":false,"errmsg":"請先開通>個人賬戶","errcode":202,"data":"https://pay.ip-localhost/userAccount/account/my.htm","time":"2014-06-22 00:18:54"}
{"ver":"1.0","ret":false,"errmsg":"請先開通個人賬>戶","errcode":202,"data":"https://pay.ip-localhost/userAccount/account/my.htm","time":"2014-06-22 00:20:29"}
####200####{"ver":"1.0","ret":false,"errmsg":"請先
開通個人賬戶","errcode":202,"data":
###200####{"ver":"1.0","ret":false,"errmsg":"請先>開通個人賬戶","errcode":202,"data":"https://pay.ip-localhost/userAccount/account/my.htm","time":"2014-06-22 00:24:18"}
#{"ver":"1.0","ret":false,"errmsg":"請先開通個人賬
戶","errcode":202,"data":"https://pay.ip-localhost/userAccount/account/my.htm","time":"2014-06-22 00:29:36"}
{"ver":"1.0","ret":false,"errmsg":"請先
開通個人賬戶","errcode":202,"data":"https://pay.ip-localhost/userAccount/account/my.htm","time":"2014-06-22 00:29:41"}
##{"ver":"1.0","ret":false,"errmsg":"請先
開通個人賬戶","errcode":202,"data":"https://pay.ip-localhost/userAccount/account/my.htm","time":"2014-06-22 00:30:12"}
#{"ver":"1.0","ret":false,"errmsg":"當(dāng)前訂單狀態(tài)是已
離店, 無法進(jìn)行申請返現(xiàn)操作","errcode":404,"time":"2014-06-22 00:31:52"}####D8764
#{"ver":"1.0","ret":false,"errmsg":"請先
開通個人賬戶","errcode":202,"data":"https://pay.ip-localhost/userAccount/account/my.htm","time":"2014-06-22 00:38:22"}
#{"ver":"1.0","ret":false,"errmsg":"請先
開通個人賬戶","errcode":202,"data":"https://pay.ip-localhost/userAccount/account/my.htm","time":"2014-06-22 00:38:39"}

關(guān)陰月飛

假設(shè)errmsg中的內(nèi)容只存在一個,號分隔：

1. awk -F, '/errmsg/{a[$3~/"$/?$3:$3FS$4]++}END{for(i in a)print i,a[i]}'  urfile

復(fù)制代碼

reyleon

珍愛積分，遠(yuǎn)離世界杯......

whatislinux

回復(fù) 2# 關(guān)陰月飛


    感謝，我試試。

MeRcy_PM

1. sed ':a;N;s/\n//g;ta' urfile | grep -Po "\"errmsg\":\".*?\"" | awk  '{a[$0]++}END{for(i in a)print i,a[i]}'

復(fù)制代碼

先去掉換行再匹配，最后awk。

whatislinux

回復(fù) 5# MeRcy_PM


    感謝