Pick latest file with respect to time

[murali]

Hi,
I need to pick latest file from the following using latest time value .
for example

Code: Select all

1) ABC020720061310.txt
2) ABC020720061510.txt
3) ABC020720060610.txt

In this ABC is the name with which the file name starts and 02072006(DDMMYYYY) is the date and 1310(24:00 HRS format) is the time.

 

In the above three file I need to pick the 2nd one which is having the latest time value.
Thanks in advance.

[loveojha2]

How these files are getting created ?
Can you know the latest timestamp without looking at the directory?
If yes then use a parameterized sequential file.
If no, use something outside ds (may be perl)(me thinks) to know the file name, use Execute Command stage (sequence job) to get the timestamp and use it as a parameter for the (server job) sequential file.

[kumar_s]

Use

Code: Select all

ls -lart | tail -1

to get the latest file and cut it to get the filename alone and pass it as parameter as specified.

[chulett]

Too bad they're on a Windows server.

You could use a regular 'dir' command and find the last entry, or this and take the first:

Code: Select all

dir /b /o-n *.txt

Bare format, Order by name reversed. Coding this using DSExecute makes the 'get the first entry' easy as the variable used to capture the screen output is an array, so it would be:

Code: Select all

ScreenOutput<1>

Substitute the actual name of your variable. Last would be a little trickier but certainly feasible.