Get the latest/recent file from FTP to local using Talend
I have to create a job in Talend which will connect to One FTP. The FTP is having various files for each day with same prefix but different timestamp appended(yyyymmddhhmmss) in the filename. Example -
MyFile20151123142020.xml
MyFile20151123154748.xml
My requirement is to pick the latest or most recent file and copy to my local.
I understand that this could be achieved either by referring to the latest timestamp in the filename or referring to the last modified time. I thought of proceeding with the later and my job looks like below -
I dont know how to proceed further and how to use the latest mtime value to pick the most recent file.
After getting file properties, wen need to sort files by mtime or by basename then pick the first.
tSortRow : sort by mtime or basename if they have same pattern.
tSampleRow : "1" to get the first
tFTPGet : file mask = row3.basename (row3 the output flow of tSampleRow)
- NodeJS: how to read (at most) the first N bytes from a file?
- How do I rename all files to lowercase?
- Store and read hash and array in files in Perl
- How to get the size of a file in MB (Megabytes)?
- Size of an open file object
- How to block file when you reading (fopen) it
- How to get Files and Form data using the Request object in FastAPI?
- Python code output to a file and add timestamp to filename
- Reading data from file object javascript gives undefined is not a function
- Python: How to read and change multiple numbers in a file without using .split
- Read in different data types from file
- How to read specific lines from a text file in PHP
- Dynamically add an Inno Setup component for all files in a folder and its subfolders
- Why is the beginning of a C file stream called `SEEK_SET`?
- java.io.FileNotFoundException: class path resource cannot be opened because it does not exist
- Linux - How to track all files accessed by a process?
- Best approach to upload the file via REST api from API gateway
- Change default text in input type="file"?
- Choose a file starting with a given string
- How Do You Add An Incrementing Number To The End Of A Duplicate File Name In Kotlin?
- How can I add a prefix to all filenames under a directory?
- Why would adding FileProvider Path option in the manifest.xml file cause OPEN button in the Appinfo window disappear?
- IOException while streaming file from HTTP response into HTTP request
- How to create a temporary text file in C++?
- Renaming files by reformatting existing filenames - placeholders in replacement strings used with the -replace operator
- accesing files in a specific directory assembly
- Writing to a Temporary File
- How can I split a large text file into smaller files with an equal number of lines?
- How to create a file in memory for user to download, but not through server?
- Which type is the portable equivalent to the C type FILE in FreePascal