get the latest file by reading the date in the filename. Post: 302261821

Sponsored Content

Top Forums UNIX for Dummies Questions & Answers get the latest file by reading the date in the filename. Post 302261821 by prsshini on Tuesday 25th of November 2008 03:36:54 PM

11-25-2008

Registered User

Hi frank, one more help please,
I do below to list my files in chronological order.
ls -ltr *.datx* | tr -s ' ' | cut -d' ' -f9

it gives me list of files like below.

lock_eicu_20081120_00000000.datx_20081120_05315400
lock_eicu_20081118_00000000.datx_20081118_06303100
lock_eicu_20081111_00000001.datx_20081111_15531300
lock_eicu_20081111_00000000.datx_20081111_06335300
lock_eicu_20081030_00000000.datx_20081030_05342900
lock_eicu_20081016_00001111.datx_20081016_15525600
lock_eicu_20081016_00000000.datx_20081016_06350500
lock_eicu_20081001_00000000.datx_20081001_05344100
lock_eicu_20080912_00000000.datx_20080912_05305200
lock_eicu_20080904_00000000.datx_20080904_05335500
lock_eicu_20080822_00000000.datx_20080822_05344200
lock_eicu_20080812_00000000.datx_20080812_06331200
lock_eicu_20080808_00000000.datx_20080808_05345200
lock_eicu_20080806_00000000.datx_20080806_06343800
lock_eicu_20080802_00000000.datx_20080804_05332000
lock_eicu_20080718_00000000.datx_20080718_06533100
lock_eicu_20080606_00000000.datx_20080606_05340600
lock_eicu_20080603_00000000.datx_20080603_06345300
lock_eicu_20080531_00000000.datx_20080602_05304300
lock_eicu_20080529_00000000.datx_20080529_06330500
lock_eicu_20080501_00000000.datx_20080501_05343900
lock_eicu_20080429_00000000.datx_20080429_06311200
lock_eicu_20071228_00000000.datx_20071228_05343100

how do i sort the files again chronologically as per the date found just after .datx?
i mean in the list if u see "lock_eicu_20071228_00000000.datx_20071228_05343100" is the oldest file as it has date 20071228 after datx. so i need to list this file first and then sort so on.

Please help. Thanks again

prsshini

View Public Profile for prsshini

Find all posts by prsshini

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Reading a file using sh with spaces in filename

Hi I am trouble parsing through a file with spaces in the filename. I need to grab "supportIDPS/SCM/windows_install/file groups/dds.fgl" and then do a md5sum on it. I am using sh. Any help is appreciated. Here is an example of the input file: 7eedbc9f7902bf4c1878d9e571addf9a ...

2. Shell Programming and Scripting

grep latest file based on date.

hi all, not sure if this has been posted b4 but i try to search but not valid. this is my question: when i do a ls -ltr there will be a list generated as follows: -rw-r--r-- 1 root sys 923260 Jan 10 04:38 FilePolling.41025.083TL021.xml -rw-r--r-- 1 root sys 1761337 Jan 10 04:40...

3. Shell Programming and Scripting

RSYNC syntax for pushing file with latest system date

OK, I am a little new to AIX 5.3 and also to scripting. I have a shell script that I wrote and am having difficulty pushing specific files by the system date. Here is my script: #!/usr/bin/sh RSYNC=/usr/local/bin/rsync SSH=/usr/local/bin/ssh KEY=<path> somekey.key RUSER=mike...

4. Homework & Coursework Questions

Matlab help! Reading in a file with a variable filename

1. The problem statement, all variables and given/known data: I want to read in a file, and plot the data in matlab. However, I do not like hardwiring filenames into my codes, so I always give the user the option to specify what the filename is. I am pretty inexperienced with matlab, so I have no...

5. UNIX for Dummies Questions & Answers

Selecting the file of latest Date

Hi Folks, I have one query that there is a folder in which daily several logs files are getting created , I reached to that location through putty but what I observer that 10 files of different date are been created with same name , what I need to see is the latest file ...let say the location is ...

6. Shell Programming and Scripting

Needed shell script to get the latest file based on date

hi i need the shell script to get the file with latest date. for example in my input folder i have files like file_20130212.txt file_20130211.txt now my output folder should have the file with latest date i.e..file_20120212.txt i want to get the latest file .. i.e is should take...

7. UNIX for Advanced & Expert Users

Want to download a latest file with current date from FTP location

Dear Friends, I need help to write a shell / perl script to download the files from FTP location, having different file names (date inside the file name). Example: Mar 5 09:24 cfx_03052013_return_file.txt Mar 6 02:13 cfx_03062013_return_file.txt Mar 7 06:40...

8. Shell Programming and Scripting

How to extract latest file by looking at date time stamp from a directory?

hi, i have a Archive directory in which files are archived or stored with date and time stamp to prevent over writing. example: there are 5 files s1.txt s2.txt s3.txt s4.txt s5.txt while moving these files to archive directory, date and time stamp is added. of format `date...

9. Shell Programming and Scripting

Find the latest file based on the date in the filename

Hi, We've a list of files that gets created on a weekly basis and it has got a date and time embedded to it. Below are the examples. I want to find out how to get the latest files get the date and time stamp out of it. Files are PQR123.PLL.M989898.201308012254.gpg...

10. UNIX for Dummies Questions & Answers

How to pick the latest file with date as one among the file name.( not exactly present date.)?

i have files like 1)20131112_abc_01.csv and 2)20131113_abc_01.csv and 3)20131113_abc_02.csv when i try to fetch the file in the next day. it shud pick the third file.. plz help me.. and i use `date +"%Y%m%d"` command to fetch..it fetches the current date...

LEARN ABOUT SUSE

bzfgrep

BZGREP(1)						      General Commands Manual							 BZGREP(1)

NAME

       bzgrep, bzfgrep, bzegrep - search possibly bzip2 compressed files for a regular expression

SYNOPSIS

       bzgrep [ grep_options ] [ -e ] pattern filename...
       bzegrep [ egrep_options ] [ -e ] pattern filename...
       bzfgrep [ fgrep_options ] [ -e ] pattern filename...

DESCRIPTION

       Bzgrep  is  used to invoke the grep on bzip2-compressed files. All options specified are passed directly to grep.  If no file is specified,
       then the standard input is decompressed if necessary and fed to grep.  Otherwise the given files are uncompressed if necessary and  fed	to
       grep.

       If  bzgrep  is  invoked as bzegrep or bzfgrep then egrep or fgrep is used instead of grep.  If the GREP environment variable is set, bzgrep
       uses it as the grep program to be invoked. For example:

	   for sh:  GREP=fgrep	bzgrep string files
	   for csh: (setenv GREP fgrep; bzgrep string files)

AUTHOR

       Charles Levert (charles@comm.polymtl.ca). Adapted to bzip2 by Philippe Troin <phil@fifi.org> for Debian GNU/Linux.

SEE ALSO

       grep(1), egrep(1), fgrep(1), bzdiff(1), bzmore(1), bzless(1), bzip2(1)

																	 BZGREP(1)

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Reading a file using sh with spaces in filename

Discussion started by: jekl5

2. Shell Programming and Scripting

grep latest file based on date.

Discussion started by: lweegp

3. Shell Programming and Scripting

RSYNC syntax for pushing file with latest system date

Discussion started by: tfort73

4. Homework & Coursework Questions

Matlab help! Reading in a file with a variable filename

Discussion started by: ds7202