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
${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