find the highest number in the file


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting find the highest number in the file
# 1  
Old 03-21-2006
find the highest number in the file

Hi,

I have a file a.txt and it has values in it

Eg :-

Quote:
12345
99555
65822
55
56566
..
..
.
I need to read through the file and find the number that is the greatest in them all.

Can any one assit me on this.

Thanks
# 2  
Old 03-21-2006
sort the file in ascending order and do tail -1 filename
or descending order and do head -1 filename

Gaurav
# 3  
Old 03-21-2006
Quote:
Originally Posted by systemali
I need to read through the file and find the number that is the greatest in them all.
This could be it, a easy method if your file size is small..

max=0

exec 4<&0
exec < file_of_nos

while read line
do
if [ $line -gt $m ]
then
max=$line
else
continue
fi
done

echo "Max no is:$max"
# 4  
Old 03-21-2006
manthasirisha, Thank u so much,

Your solution works great, but it does not go beyond 5 lines,..what if i have 10 lines...how can i modify the script to suite that.


Thank you so much once again.
# 5  
Old 03-21-2006
maxnum=$(sort -n a.txt |tail -1)
# 6  
Old 03-21-2006
systemali,

i tried the script with an input file of more that 50 lines and it worked... check ur shell compatibility..

anyway, the easiest method is suggested above .. it should do the trick!

good luck,
Sirisha
# 7  
Old 03-21-2006
Hi Sirisha,

Yes that worked just fine Smilie, now i have another file which is in decimals :

Quote:
eg :-
1.2.3.9
1.2.3.4
1.2.3.11
1.2.3.10
1.0.0.1
Those are actually versions and I need to find the highest version number from the list above, How can this be accomplished.

Thanks for all your assistance.
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Sort from highest to lowest number

Hi Guys, I am looking for a way to sort the output below from the "Inuse" count from Highest to Lowest. Is it possible? Thanks in advance. user1 0.12 0.06 0 0.12 User Inuse Pin Pgsp Virtual Unit:... (4 Replies)
Discussion started by: jaapar
4 Replies

2. Shell Programming and Scripting

Only print the entries with the highest number?

Just want to say this is great resources for all thing Unix!! cat tmp.txt A 3 C 19 A 2 B 5 A 1 A 0 C 13 B 9 C 1 Desired output: A 3 B 9 C 19 The following work but I am wondering if there is a better way to do it: (4 Replies)
Discussion started by: chirish
4 Replies

3. Shell Programming and Scripting

Find highest number - working but need help!

Hello all, I am new to this and need some help or maybe steer me to the right direction! I wrote a script to get the highest number and prints it on the screen, the script basically asks the user to input numbers, and then prints the highest number! very simple it works like this $sh max.sh... (8 Replies)
Discussion started by: unknownsolo
8 Replies

4. 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

5. Shell Programming and Scripting

the smallest number from 90% of highest numbers from all numbers in file

Hello All, I am having problem to find what is the smallest number from 90% of highest numbers from all numbers in file. I am having file with thousands of lines and hundreds of columns. I am familiar mainly with bash but I am open to whatever suggestion witch will lead to the solutions. If I... (11 Replies)
Discussion started by: Apfik
11 Replies

6. Shell Programming and Scripting

Bash, finding highest number in another file

i have a problem i am working on and am completely new to bash commands. I writing a script to read another file and output the max and Min number in the script. I must use variables to output the max and min numbers. grades = file with numbers in them. This is what i got so far. Thank You in... (3 Replies)
Discussion started by: ctanner10126
3 Replies

7. Shell Programming and Scripting

How to only display lines where a field has the highest number?

Hello Wondering if anybody can advise me how I can sort the below file so it only displays lines with the latest versions of an object? As you'll see some of the scripts listed in my file have more than one version number (version number is after the file extension). E.g. cdm_bri.pkb has... (2 Replies)
Discussion started by: Glyn_Mo
2 Replies

8. Shell Programming and Scripting

Extract the highest number out

Hi Gurus, I've using HPUX B.11.23 U ia64 with shell = sh. I've been having some problem get the highest number of this script. Actually I wanted to get the highest number from this listing (TEST123 data and based on this highest number, there will be email being sent out. For example,... (6 Replies)
Discussion started by: superHonda123
6 Replies

9. Shell Programming and Scripting

Displaying lines of a file which have the highest number?

Hello Wondering if anybody may be able to advise on how I can filter the contents of the following file: <object_name>-<version> <Instance> GM_GUI_code.fmb-4 1 GM_GUI_code.fmb-5 1 GM_GUI_code.fmx-4 ... (7 Replies)
Discussion started by: Glyn_Mo
7 Replies

10. Shell Programming and Scripting

Finding line with highest number in a file

Hi All, My file looks some thing like this, File 1: - A 10 B 30 C 5 D 25 E 72 F 23 now my requirement is to find the line with highest number in it, i;e the result should be E 72 Thanks in Advance (1 Reply)
Discussion started by: balu_puttaganti
1 Replies
Login or Register to Ask a Question