using uniq and awk?? - Page 2 - Shell Programming and Scripting

amatuer_lee_3 · #8 (**permalink**) 05-17-2008

ok that works perfectly thank you.

how do i sort this code so that the number of hits per page is sorted in descending order?

so the code which is this:

Code:

awk -F'[: ]' 'END {
fmt = "%-20s\t%s\t%s\n"
printf fmt, "Page:", "Hits:", "Unique Hits:"
for (p in h)
  printf fmt, p, h[p], u[p]
}
!_[$1,$2]++ { u[$1]++ }
{ h[$1]++ }' HITS

needs to be edited so that the output looks like this:

Code:

Page:                 Hits:  Unique Hits:
hits/blog.hits      	124	84
hits/mags.hits      	119	79
hits/dvds.hits      	48	35
hits/food.hits      	46	40
hits/news.hits      	42	40
hits/jobs.hits      	33	29

era · #9 (**permalink**) 05-17-2008

Pipe to sort -k2rn. Maybe some hack to print the header separately.

amatuer_lee_3 · #10 (**permalink**) 05-17-2008

so where about does that go into the code? (sorry i am a bit of a beginner.)

era · #11 (**permalink**) 05-17-2008

Code:

awk -F'[: ]' 'END {
fmt = "%-20s\t%s\t%s\n"
printf fmt, "Page:", "Hits:", "Unique Hits:"
for (p in h)
  printf fmt, p, h[p], u[p]
}
!_[$1,$2]++ { u[$1]++ }
{ h[$1]++ }' HITS |
( IFS='' read header; echo "$header"; sort -k2rn )

The read takes one line off and prints it, leaving the rest as input to sort.

amatuer_lee_3 · #12 (**permalink**) 05-17-2008

Thank you very much.

How the hell do you guys learn all this sooo quickly. Its mental.

ripat · #13 (**permalink**) 05-17-2008

Quote:

Originally Posted by radoulov

Another one
(use nawk or /usr/xpg4/bin/awk on Solaris):

Code:

awk -F'[: ]' 'END {
fmt = "%-20s\t%s\t%s\n"
printf fmt, "Page:", "Hits", "Unique Hits"
for (p in h)
  printf fmt, p, h[p], u[p]
}
!_[$1,$2]++ { u[$1]++ }
{ h[$1]++ }' file

That's neat and terse! Exactly the way I like it! I should have thought to use a regex as FS.

learnbash · #14 (**permalink**) 05-17-2008

Thats why i like to say to say era is really a nice person and understand problem and reply the solution quickly.

Regards,
Bash

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
uniq command???	skyineyes	UNIX for Dummies Questions & Answers	2	05-28-2008 03:27 AM
uniq options	dhanamurthy	Shell Programming and Scripting	0	05-08-2008 05:08 AM
Uniq using only the first field	Digby	UNIX for Dummies Questions & Answers	8	01-16-2008 02:25 AM
help on UniQ	vishal_ranjan	HP-UX	0	06-21-2007 07:33 AM
sort/uniq	jimmyflip	UNIX for Dummies Questions & Answers	3	10-17-2002 02:09 AM

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode