Need command to pick the latest file


 
Thread Tools Search this Thread
Top Forums UNIX for Dummies Questions & Answers Need command to pick the latest file
# 1  
Old 03-16-2011
Need command to pick the latest file

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

Last edited by vbe; 03-16-2011 at 10:49 AM.. Reason: please use code tags!
# 2  
Old 03-16-2011
Code:
$> grep \.csv infile| sort -t"_" -n -k5,5| tail -1
Supplier_Mapping_Table_4007_131411.csv

# 3  
Old 03-16-2011
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
# 4  
Old 03-16-2011
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
# 5  
Old 03-17-2011
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
 
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Should pick latest file within past 3 days using UNIX script and perform steps in message below.

Hi , Can anyone help me how do perform below requirement in unix. Step1:we will receive multiple files weekly with same name(as below) in a folder(In folder we will have other files also def.dat,ghf.dat) Filenames: 1) abc_20171204_052389.dat 2)abc_20171204_052428.dat DON'T modify... (23 Replies)
Discussion started by: sunnykamal59
23 Replies

2. Shell Programming and Scripting

I have this list of files . Now I will have to pick the latest file based on some condition

3679 Jul 21 23:59 belk_rpo_error_**po9324892**_07212014.log 0 Jul 22 23:59 belk_rpo_error_**po9324892**_07222014.log 3679 Jul 23 23:59 belk_rpo_error_**po9324892**_07232014.log 22 Jul 22 06:30 belk_rpo_error_**po9324267**_07012014.log 0 Jul 20 05:50... (5 Replies)
Discussion started by: LoneRanger
5 Replies

3. 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... (2 Replies)
Discussion started by: applepie
2 Replies

4. Shell Programming and Scripting

to pick the latest file modified in a directory

I wan to pick the latest modified file name and redirect it to a file .. ls -tr | tail -1 >file but this is printing file ins side the filename , can anyone help me out (5 Replies)
Discussion started by: vishwakar
5 Replies

5. UNIX for Dummies Questions & Answers

How to pick only the latest files based on the timestamp?

I have a few log files which get generated on a daily basis..So, I need to pick only the ones which get generated for that particular day. -rw-r--r-- 1 staff 510732676 Apr 7 22:01 test.log040711 -rwxrwxrwx 1 staff 2147482545 Apr 7 21:30 test.log.2 -rwxrwxrwx 1 staff 2147482581 Apr 7 19:26... (43 Replies)
Discussion started by: win4luv
43 Replies

6. Shell Programming and Scripting

Find the latest directory and loop through the files and pick the error messages

Hi, I am new to unix and shell scripting,can anybody help me in sctipting a requirement. my requirement is to get the latest directory the name of the directory will be like CSB.monthdate_time stamp like CSB.Sep29_11:16 and CSB.Oct01_16:21. i need to pick the latest directory. in the... (15 Replies)
Discussion started by: sudhir_83k
15 Replies

7. Shell Programming and Scripting

Pick random file from ls command.

Lets say I want to pick a random file when I do an "ls" command. I don't have set number of files in each directory. ls | head -1 This gives me the first one in each directory, is there a way to do the same but pick a random one. (3 Replies)
Discussion started by: elbombillo
3 Replies

8. UNIX for Dummies Questions & Answers

pick the very latest directory

Hi, I have some list of directories in the form datemonthyear e.g. 02082009, 03082009 and 04082009 etc. I need to pick the latest directory from the current working directory. Outcome: 05082009 This is the output am expecting. Thanks (6 Replies)
Discussion started by: venkatesht
6 Replies

9. Shell Programming and Scripting

how can i pick the latest log file as per below

in the below .. i want to pick the latest logfile which is having JPS.PR inside.. that means i want particularly "spgport040408041223.log:@@@@@@@@ 04:13:09 Adding: JPS.PR." which is latest among these.. is it possible to compare the current time with logfile time ? reptm@xblr0758rop>... (4 Replies)
Discussion started by: mail2sant
4 Replies

10. Shell Programming and Scripting

Pick the latest set of files

I have task in which I need to pickup a set of files from a directory depending on the following criteria: Every month 6 files are expected to arrive at /test. The files come with date timestamp and the latest file set for the month needs to be used Suppose this is the set of files that present... (5 Replies)
Discussion started by: w020637
5 Replies
Login or Register to Ask a Question