using uniq and awk?? - Page 3

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

Other UNIX.COM Threads 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	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode