How to calculate the maximum value & min value

gobinath · #1 (**permalink**) 05-28-2008

I have a file as like below,

Code:

10:20:30.45 	START 	10.20.30.40
10:20:31.46 	HELLO 	10.20.30.40
10:20:32.46	START 	10.20.30.41
10:20:33.44	END   	10.20.30.40
10:20:35.44 	HELLO 	10.20.30.41
10:20:36.56 	HELLO 	10.20.30.41
10:20:37.78 	HELLO 	10.20.30.41
10:20:38.99 	START 	10.20.30.40
10:20:39.11 	HELLO 	10.20.30.41
10:20:40.23 	HELLO 	10.20.30.40
10:20:41.23 	END 	10.20.30.41
10:20:45.45 	HELLO 	10.20.30.40
10:20:47.66 	HELLO 	10.20.30.40
10:20:50.32 	END 	10.20.30.40

I need the output like this,

Code:

No. Of Hello for 10:20:30:40 - 1
No. Of Hello for 10:20:30:41 - 4
No. Of Hello for 10:20:30:40 - 3

Also,

Code:

END - START for IP 10:20:30:40 -(10:20:33.44-10:20:30.45)=2.99
END - START for IP 10:20:30:41 -(10:20:41.23-10:20:32.46)=8.77
END - START for IP 10:20:30:40 -(10:20:50.32-10:20:38.99)=11.33

Note: Same IP will be get repeated, but i need a seperate "count" & "Time taken" of HELLO for the same IP at different session...Please help me out to solve this

Thanks in advance

gobinath · #2 (**permalink**) 05-29-2008

Changing the title

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
How To Calculate	krishna_sicsr	Shell Programming and Scripting	3	03-21-2009 01:49 PM
calculate 13 months ago	andrea_mussap	Shell Programming and Scripting	3	11-16-2007 03:18 PM
how to calculate CPU time under HP-UX	limame	HP-UX	1	06-18-2007 05:28 PM
How to calculate with awk	whatisthis	Shell Programming and Scripting	4	11-09-2005 12:39 PM
How to calculate a sum of certain records?	sickboy	Shell Programming and Scripting	10	06-10-2005 11:43 AM

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread:


	Powered by