Finding max number in filename and opening it


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Finding max number in filename and opening it
# 1  
Old 12-25-2011
Finding max number in filename and opening it

Hi,

I have files named as

energy.dat.1
energy.dat.2
energy.dat.3
...
energy.dat.2342

I would like to find the file with maximum number in the filename (ex. energy.dat.2342) and open it.

Would you please share your expertize in writing the script?

Thanks in advance.
# 2  
Old 12-25-2011
Code:
ls energy.dat.*|sort -rn|head -1

This User Gave Thanks to vbe For This Post:
# 3  
Old 12-25-2011
I tried the command. However it gave max file number as 99 (although the folder contains thousands of file)

$ls energy.dat.*|sort -rn|head -1
energy.dat.99

Is there any way to store the file name with maximum number in a variable?
I want to open this file for plotting in octave/gnuplot/python/scilab.

Thanks you.
# 4  
Old 12-25-2011
Try this:
Code:
energy.dat.* | awk -F\. 'm<$NF{m=$NF;s=$0}END{print s}'

This User Gave Thanks to Franklin52 For This Post:
# 5  
Old 12-25-2011
Quote:
Originally Posted by rpd25
Is there any way to store the file name with maximum number in a variable?
I want to open this file for plotting in octave/gnuplot/python/scilab.
Thanks you.
if you want it to store in a variable , just use the below command:
Code:
max_number=`ls energy.dat.*|sort -rn|head -1`

This User Gave Thanks to pandeesh For This Post:
# 6  
Old 12-25-2011
A slight modification to vbe's one-liner:

Code:
ls energy.dat.* | sort -nrk1.12 | head -1

This User Gave Thanks to balajesuri For This Post:
# 7  
Old 12-25-2011
Quote:
Originally Posted by balajesuri
A slight modification to vbe's one-liner:

Code:
ls energy.dat.* | sort -nrk1.12 | head -1

Hi,
Could you please explain how that command behaved without key -k specification .
I don't have unix to test it currently

Thanks
This User Gave Thanks to pandeesh For This Post:
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Finding max of a column grouping by the time

Hi, I have the below text: 16:00 0.50 16:00 0.30 16:00 0.00 16:00 0.00 16:00 0.30 16:01 0.00 16:01 0.30 I want to find the max of the 2nd column grouping by the values in the 1st column using awk. So 16:00 0.50 16:01 0.30 I have tried (3 Replies)
Discussion started by: satishrao
3 Replies

2. Shell Programming and Scripting

finding max size

Hi I have a list of 2000 records with multiple entries and I want to get the max size for each entry ABC 1 ABC 2 ABC 3 ABC 4 DEF 1 DEF 2 DEF 2 DEF 2 DEF 2 ... (9 Replies)
Discussion started by: Diya123
9 Replies

3. UNIX for Dummies Questions & Answers

Select max value based on filename

Hi, I would just like to know how to get the file with the max filename on a directory and get rid of all the others. For example, in directory A:/ i have the ff files: APPLE2001 APPLE2002 APPLE2003 GRAPE2004 what I want to get is the max in files whose filenames start with APPLE*,... (4 Replies)
Discussion started by: madden
4 Replies

4. Shell Programming and Scripting

Max number of variables?

Hi Folks.Just out of interest does anyone know if their is a maximum number of variables that korn shell supports and if so how do I query what it is?Cheers (1 Reply)
Discussion started by: steadyonabix
1 Replies

5. Shell Programming and Scripting

Finding Max value from an array

Hi, I need to find max and second max element from an array. array contains 0338,0337,0339,0340,0401,0402,0403 (10 Replies)
Discussion started by: vjasai
10 Replies

6. Shell Programming and Scripting

find max number

Hi, i have a file with numbers in it and i was wondering if there's a script i could use to find the max number and have that printed to a new file? example a.txt 18 26 47 34 27 so find the max number in a.txt and print it to b.txt. Thanks! (17 Replies)
Discussion started by: moonbaby
17 Replies

7. Shell Programming and Scripting

Finding opening and closing braces

I am reading a cpp file thru shell script . There are many fuctions inside the cpp file eg pvvd_fncn_name1 { ..... something } pvvd_fncn_name2 { ..... something } what I require is a method to find the first opening brace and the coresponding last brace and search... (2 Replies)
Discussion started by: ultimatix
2 Replies

8. Solaris

Max. Possible number of IOs

Hi, Is there a way to find out the maximum possible number of IOs on a Solaris Servers. I'm using SUN Fire V240 (2 Replies)
Discussion started by: justsam
2 Replies

9. Shell Programming and Scripting

Help in finding the max and min position

Hi, I have this input file called ttbitnres (which is catenated and sorted):- 8 0.4444 213 10 0.5555 342 11 0.5555 321 12 0.5555 231 13 0.4444 400 My code is at :- #!/bin/bash echo -e Version "\t" Number of Pass "\t" Number of Fail "\t" Rank Position "\t"Min "\t" Max... (1 Reply)
Discussion started by: ahjiefreak
1 Replies

10. Shell Programming and Scripting

Finding max value

My code below is supposed to find which company had the most business and then print the appropriate fields from another file which are the companies ID number and name. I can loop through awk and display all the total amount of business for each company but I need help in only printing out the... (1 Reply)
Discussion started by: Enigma23
1 Replies
Login or Register to Ask a Question