?
Solved

uniq -c issue

Posted on 2011-09-08
3
Medium Priority
?
278 Views
Last Modified: 2012-06-27
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
0
Comment
Question by:Kent Dyer
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 48

Accepted Solution

by:
Tintin earned 2000 total points
ID: 36506788


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

Open in new window

0
 
LVL 17

Author Closing Comment

by:Kent Dyer
ID: 36508062
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
 
LVL 17

Author Comment

by:Kent Dyer
ID: 36508092
Duh..  head -30 should do the trick.

Thanks,

Kent
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This Windows batch file is useful for organizing image files from a digital camera or other source, but can have many other uses.  It simply renames the file(s) to match their create date.  For example, if you took a picture today at 1:40pm and the …
Over the years I've spent many an hour playing on hardened, DMZ'd servers, with only a sub-set of the usual GNU toy's to keep me company; frequently I've needed to save and send log or data extracts from these server back to my PC, or to others, and…
Learn several ways to interact with files and get file information from the bash shell. ls lists the contents of a directory: Using the -a flag displays hidden files: Using the -l flag formats the output in a long list: The file command gives us mor…
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question