Solved

uniq -c issue

Posted on 2011-09-08
3
268 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
  • 2
3 Comments
 
LVL 48

Accepted Solution

by:
Tintin earned 500 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Problem to cmd 2 79
reading text file and converting it to csv 8 66
Linux "time" command output redirection 16 114
Shell Script on AIX 7 62
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 …
The following is a collection of cases for strange behaviour when using advanced techniques in DOS batch files. You should have some basic experience in batch "programming", as I'm assuming some knowledge and not further explain the basics. For some…
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…
Need to grow your business through quality cloud solutions? With everything required to build a cloud platform and solution, you may feel like the distance between you and the cloud is quite long. Help is here. Spend some time learning about the Con…

914 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now