Latest Files from FTP

[seansku]

Hi Guys,

I currently use Insert URL in order to download certain files from an external FTP location, which I have managed to get working perfectly using the following curl options

--user " & $usr & ":" & $pw & " -o Stock-Summary.csv"

This works as hoped and downloads the file from the FTP, however, the company who provides us with these files has "moved the goalposts" so to speak.

For whatever reason they are now prefixing and suffixing random numbers to said file, so I need to tweak this to somehow only get the latest version of this file which now looks something like this -

Quote

7818023-Stock_Summary-035831

Any advice or different approaches would be greatly appreciated as I am simply a novice trying to help out a family friend.

 

Thanks