Only download most recent file regular expression ftp file

I want to write a process that can find and download all the files associated with a particular date. The complication is that different files use different encodings.

The year can be four digits or two. The month can be two digits or three letters. Sometimes the day is represented, and the substring can be anywhere in the string. At the moment, I'm creating a list of all the files on the server, then using a regular expression to determine which files are relevant, and then downloading those files. Is it possible to condense the first two steps? That is, is there a way to get the server to return the list of files that match the expression?

The available commands that list files on the remote server are LIST , MLSD and NSLT , and for all of them the only available argument is the name of the directory - there's no way to filter files, by regex or otherwise. It's not a big overhead to get the listings and parse them in the client, though, unless you're dealing with millions of files.

Stack Overflow for Teams — Collaborate and share knowledge with a private group. Is it possible to get only the latest file from the list? Posted 1-Mar am ramesh Add a Solution. Top Rated Most Recent. Accept Solution Reject Solution. This code has helped me before Copy Code. Posted 1-Mar am Dylan Morley. Sandeep Mewara 1-Mar am. For answer For Full souce code.. Sandeepdshenoy Dec am. James Rimmer Apr pm.

Thank you for the information. Its really useful. I have another situation where i download file from FTP locations, and i have sorted the list of files based on date. Now i want to upload the sorted files on the shared drive.

How should I achieve it? I tried using download tool, but invain. Any quick help? I am having an issue with the download tool.

I have followed the instructions, and even tested the URL to ensure that it works, but when the tool goes to actually download the files from the FTP I get the following:. In the text input I inserted a second column where I indicated the path to save the data; after which I entered the "filename from a field" in the basic third banner window by selecting the column with the specified path.

I modified the path and inserted the name of the files that should download but the zip file that is generated is empty, and then reading the result in the browser tool known this:. Mine never shows the year only the month, day, and time. I have tried with multiple FTP servers, and all of them show the year in the filezilla but no year in alteryx.

MattD any thoughts on my comment above? In your screenshot, it shows your date as "". Notice in my screenshot below it shows the date like so:. How did you get your date to show the year in the download tool? I have tried multiple FTP servers for clients ours and theirs and they all appear like this in alteryx.

Who knows? Some of you folks out there might find it useful. Better yet, you might be able to contribute your own expressions so that we can all benefit from them. Sounds like a plan? Let's get this ball rolling. Using Regular Expressions in Triggers - Part 1. The general problem is usually like this. The customer has a boatload of files on a remote server but he only wants to download those files whose filenames follow a certain format.

Usually, that format involves date information. These include:. Choosing the right trigger action is the easy part. Composing the right regular expression?