find the most recent file from a list of files

[mpramods]

I have a file that is generated every week. Its name is going to be in the following format:
${businessname}${datecreated}7890.

e.g.

SCF2004010207890.dat
SCF2004010907890.dat
SCF2004011607890.dat
SCF2004012307890.dat
SCF2004013007890.dat

The businessname & last four digits are going to remain same except the date is going to change every week.

Every week I have to run a job to load the most recent file from the above list.
How can I find the most recent file from the above list and export it to the main job.


Thanks,
mp

 

[sbix]

cat list|sort -r|line
or
ls -t|line

 

[aigles]

try this :
[tt]
ls -1 SCF*7890.dat | head +1
[/tt]


Jean Pierre.

 

[vgersh99]

sort myFile | tail -1

vlad
+----------------------------+
| #include<disclaimer.h> |
+----------------------------+

 

[mpramods]

I forgot to mention that this is not a list but the files in a directory.

So I cannot say cat list.

I have to export this filename from the unix script, so that the main job will pick this as the source file every time it runs.

Thanks
mp

 

[apb99]

LATEST_FILE=`ls -lat sap*| head -1|awk '{ print $9 }'`
export LATEST_FILE

alan

 

[sbix]

ls -t SCF*dat|line

 

[forbush]

sort -n +0.4 data


if the file were named data.

 

[forbush]

sort -n +0.4 data -r | line

to reverse sort and pop off the most recent file name