UNIX for Dummies Questions & Answers

Hi
In my script i am trying to access mainframe server using FTP,
in the server i have filee with the timestamp.I need to get the file with the latest timestamp among them . The server has the below files

Code:

/
ftp> cd /outbox
250 CWD command successful
ftp> ls
200 PORT command successful
150 Opening ASCII mode data connection for file list
VTTTERMS.FILE.AIRCRAFT.CSV
VTTTERMS.FILE.AVITNSYS.CSV
Supplier_Mapping_Table_4007_013111.csv
Supplier_Mapping_Table_4007_020711.csv
Supplier_Mapping_Table_4007_021411.csv
Supplier_Mapping_Table_4007_022211.csv
Supplier_Mapping_Table_4007_030711.csv
Supplier_Mapping_Table_4007_031411.csv
Supplier_Mapping_Table_4007_022811.csv
/

The Supplier_Mapping_Table_4007*.csv files comes every monday or tuesday of every week for the month.
in the above case i need to pick the file "Supplier_Mapping_Table_4007_031411.csv. "
As the files is generated on Monday, Suppose if the run my script next week on wednesday i need to pick the file with the name
Supplier_Mapping_Table_4007_032111.csv.

or any command to generate the date in 032111(mmddyy)format , it should have the dates of every monday or tuesday's date

The best would be to pick the latest file

Need help to pick the latest file

Thanks

Code:

$> grep \.csv infile| sort -t"_" -n -k5,5| tail -1
Supplier_Mapping_Table_4007_131411.csv

hi
AS the file from which we FTP is mainframe server we cannot use any unix command like grep, tail, sort
Is ther any way where we can get the date like tuesday's date or monday's date for the current week and store that in a variable
for eg
var=031411
get Supplier_Mapping_Table_4007_$var.csv.

Can we need to get every tuesday or monday's date for the current week
and based on that we can get the file ?

Thanks

What Operating System and version are you running on the local server?
What Shell do you use on the local server?

The usual solution is to do this in three stages.
1) Use ftp to get the files list to a file on the local server
2) Process the files list to produce a selected list. Is is trivial to find the latest file with these filenames.
3) Run ftp to copy files listed in the selected list

Is ther any way or any command where we can get the date like tuesday's date or monday's date for the current week