Extract the highest number out


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Extract the highest number out
# 1  
Old 06-30-2010
Question 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, the number used is: 60 and if I used my method below, the script will display 3 numbers and send out an email 3 times.

How can it be fixed to display on the highest number (91) and send out email only 1 time?

Please kindly advice. Thanks a lot.

Code:
TEST123 (sample data):
17
65
84
54
0
60
39
46
2
91

for VAL1 in `cat TEST123`; do
  if [ $VAL1 -gt 60 ]; then
    echo $VAL1
    #perform mailx command ... mailx ...
   fi
done

Actual output:
65
84
91

Desired output
91



Regards,
Peter
# 2  
Old 06-30-2010
Hi

Code:
sort -n file | tail -1

Guru.
# 3  
Old 06-30-2010
Hi guruprasadpr,

Thanks for your response.

However, due to certain information that is tied to data in "TEST123", this data should not be manipulated, change order sequence, etc.

Anybody would be able to help me in getting the desired output?

Thanks a lot.


Regards,
Peter
# 4  
Old 06-30-2010
Quote:
Originally Posted by superHonda123
this data should not be manipulated
You may use a "copy", then:

Code:
MAX_VAL=$( cat file | sort -n | tail -1 )

# 5  
Old 06-30-2010
Quote:
Originally Posted by superHonda123
Hi guruprasadpr,

Thanks for your response.

However, due to certain information that is tied to data in "TEST123", this data should not be manipulated, change order sequence, etc.

Anybody would be able to help me in getting the desired output?

Thanks a lot.


Regards,
Peter
Peter...i did not get what you mean by manipulating data or changing order sequence..since the original file is in-tact.

However, to fix your original code:

Code:
max=0
for VAL1 in `cat TEST123`; do
  if [ $VAL1 -gt $max ]; then
    max=$VAL1
   fi
done
echo "The max value is $max"

Guru.
# 6  
Old 06-30-2010
It is preferable to use a while read construction:
Code:
maxval=0
while read val
do 
  if [ $val -gt $maxval ]; then 
    maxval=$val
  fi
done < infile
echo $maxval

# 7  
Old 06-30-2010
Hi guruprasadpr,

Sorry, I've misunderstood your reply.

I've tried your method and it's working.

Thanks a lot for your help.



Regards,
Peter

---------- Post updated at 09:56 AM ---------- Previous update was at 07:57 AM ----------

Hi All,

Thank you for your response and help.

I've tested all your methods and it's working as expected. Smilie



Regards,
Peter
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

Filtering out duplicates with the highest version number

Hi, I have a huge text file with filenames which which looks like the following ie uniquenumber_version_filename: e.g. 1234_1_xxxx 1234_2_vfvfdbb 343333_1_vfvfdvd 2222222_1_ggggg 55555_1_xxxxxx 55555_2_vrbgbgg 55555_3_grgrbr What I need to do is examine the file, look for... (4 Replies)
Discussion started by: mantis
4 Replies

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

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

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

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

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

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

10. Shell Programming and Scripting

find the highest number in the file

Hi, I have a file a.txt and it has values in it Eg :- 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 (30 Replies)
Discussion started by: systemali
30 Replies
Login or Register to Ask a Question