uniq -c issue

Let me try this again..

I have the following:
sed -n "s/ns1://g;s/:ns1//g;/signin xmlns/,/signin/p;/\<signin.*/,/<\/signin>/{/\<orgName>/s/\<orgName><*/orgName>/};{/\<userName>/s/\<userName>[^m][^o][^n][^i][^t][^o][^r][^A][^c][^c][^t][^<]*/userName>/};{s/\<orgName>/<\/orgName>/}" "Apache_log" | gawk "/orgName/" { print substr($1,10,length($1)-19) }"|sort|uniq -c

Open in new window


Which works great..

However, I am wanting to change the output of uniq -c from:
22 ORG_NAME

to:
22,ORG_NAME

Thanks,

Kent
LVL 17
Kent DyerIT Security Analyst SeniorAsked:
Who is Participating?
 
TintinCommented:


uniq -c | sed "s/\([0-9]\) /\1,/"

Open in new window

0
 
Kent DyerIT Security Analyst SeniorAuthor Commented:
Awesome!  Now, just need to figure out to get the top 5 lines..

gawk "/orgName/ { print substr($1,10,length($1)-19) }"  logfile | sort | uniq -c | gawk "{ print $2,$1}" | sed "s/\([0-9]\) /\1,/" | sort -r -n

Open in new window


And this now works, but now I need to just show the top five counts from the results.
0
 
Kent DyerIT Security Analyst SeniorAuthor Commented:
Duh..  head -30 should do the trick.

Thanks,

Kent
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.