checking the smallest and largest number


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting checking the smallest and largest number
# 1  
Old 04-24-2008
checking the smallest and largest number

Hi All,

My script is reading a log file line by line
log file is like ;

19:40:22 :INFO Total time taken to Service External Request---115ms
19:40:25 DEBUG : Batch processed libdaemon.x86_64 0-0.10-5.el5 - u
19:40:22 INFO Total time taken to Service External Request---20ms
19:40:24 DEBUG : Adding libgtk-java - 2.8.7-3.el5.x86_64 in mode u
19:40:22 INFO : Total time taken to Service External Request---10ms


While reading i am catching numbers 115,20,10 from respective lines..
How can i check the smallest and largest numbers from this?

Thanks
Subin
# 2  
Old 04-24-2008
awk '{if($NF ~ "ms" ){ sub("Request---","", $NF ); sub("ms",""); print $NF}}' patterns | sort -n

Best Regards,
Rakesh UV
# 3  
Old 04-24-2008
Hi ,

Thanks for the reply. But its not working for me..

while read data
do
STR_TOTALTIME=`echo $data | egrep "*.Visited URL.*ms"`
COUNT_TOTALTIME=`echo $STR_TOTALTIME | awk '{print $NF}' | awk 'BEGIN {FS="-";}{print $4}'| awk 'BEGIN {FS="m";}{print $1}'`


By using this code i am getting the value 115,20 and 10 respectively in COUNT_TOTALTIME varable.How can i print the smallest and largest values in the log file?
# 4  
Old 04-24-2008
Try this:

Code:
awk -F- '
/INFO/{v=int($NF)}
{if(NR==1){min=max=v;next}}
{if(max<v){max=v}if(min>v){min=v}}
END{print "Min: " min,"Max: "max}' file

Regards
# 5  
Old 04-24-2008
hi
Code:
awk -F"-" '/INFO/{print $NF}' new | tr 'ms' '  ' | sort -n >> pp
echo "Largest time :: `tail -1 pp` "
echo "Smallest time :: `head -1 pp` "


Last edited by Franklin52; 06-23-2010 at 05:53 AM.. Reason: adding code tags
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Bash script to print the smallest floating point number in a row that is not 0

Hello, I have often found bash to be difficult when it comes to floating point numbers. I have data with rows of tab delimited floating point numbers. I need to find the smallest number in each row that is not 0.0. Numbers can be negative and they do not come in any particular order for a given... (9 Replies)
Discussion started by: LMHmedchem
9 Replies

2. Shell Programming and Scripting

Problem facing to compare different column and print out record with smallest number

Hi, Input file 1 : 37170 37196 77 51 37174 37195 73 52 37174 37194 73 53 Desired Output file 1 : 37170 37196 77 51 Input file 2 : 37174 37195 73 0 37170 37196 77 0 Desired Output file 2 : 37174 37195 73 0 (1 Reply)
Discussion started by: cpp_beginner
1 Replies

3. Shell Programming and Scripting

Problem to print out record got smallest number in specific column

Hi, Anybody know how to print out the record that shown smallest number among column 3 and column 4 Case 1 Input : 37170 37196 77 51 37174 37195 73 52 37174 37194 73 53 Case 1 Output : 37170 37196 77 51 Case 2 Input : 469613 469660 73 ... (4 Replies)
Discussion started by: cpp_beginner
4 Replies

4. Shell Programming and Scripting

Find smallest & largest in every column

Dear All, I have input like this, J_15TEST_ASH05_33A22.13885.txt: $$ 1 MAKE SP1501 1 1 4 6101 7392 2 2442 2685 18 3201 4008 20 120 4158 J_15TEST_ASH05_33A22.13885.txt: $$ 1 MAKE SP1502 1 1 4 5125 6416 2 ... (4 Replies)
Discussion started by: attila
4 Replies

5. Shell Programming and Scripting

Use a string in one column to get the largest or the smallest of another column

I have data that looks like this: chr1 mm9_knownGene exon 155747075 155747189 0.000000 + . gene_id "Glul"; transcript_id "uc007daq.1"; chr1 mm9_knownGene exon 155750064 155750076 0.000000 + . gene_id "Glul";... (3 Replies)
Discussion started by: pbluescript
3 Replies

6. Shell Programming and Scripting

Print smallest negative number with corresponding index from a column

considering the following table: ID col1 col2 col3 col4 1 -16.06801249 13.49785832 -56.57087607 -27.00500526 2 -1.53315720 0.71731735 -42.03602078 -39.78554623 3 -1.53315190 0.71731587 -42.03601548 ... (3 Replies)
Discussion started by: Birda
3 Replies

7. Shell Programming and Scripting

Largest number in array. Help!

I need to calculate the biggest number in array size n. Example: Users enter: 1 7 4 9 The biggest number is : 9 Simple but I'm really new on this on Shell/Bash! Anything will be helpful! Thanks! #!/bin/bash printf "\tEnter a list of numbers, with spaces: " read -a ARRAY BIG=$1... (5 Replies)
Discussion started by: Sundown
5 Replies

8. Programming

Help with find highest and smallest number in a file with c

Input file: #data_1 AGDG #data_2 ADG #data_3 ASDDG DG #data_4 A Desired result: Highest 7 Slowest 1 code that I try but failed to archive my goal :( #include <stdio.h> (2 Replies)
Discussion started by: cpp_beginner
2 Replies

9. Shell Programming and Scripting

AWK (how) to get smallest/largest nr of ls -la

Hey, This is a long-shot however, I am stuck with the following problem: I have the output from ls -la, and I want to sort some of that data out by using AWK to filter it. ls -la | awk -f scriptname.awk Input: For example: drwxr-xr-x 3 user users 4096 2010-03-14 20:15 bin/... (5 Replies)
Discussion started by: abciscool
5 Replies

10. UNIX for Dummies Questions & Answers

How to print largest and smallest number.

Hey. This is pretty easy stuff but I'm learning the basics of Unix at the moment so keep that in mind. I have to: 1) Write a C-shell script to monitor user activity on the server for 13 minutes. 2) Then print the smallest and largest number of users during these 13 minutes. I have this: 1)... (2 Replies)
Discussion started by: amp10388
2 Replies
Login or Register to Ask a Question