Hi all,
Everyday different reports are exported with date and time stamp to the root folder of FTP server. Files never get deleted and now has thousands of reports. Example of report files:
Report_20240404_05_01_40_AM.csv
FinalReport_20240404_05_09_42_AM.csv
IntrimReport_20240404_05_15_42_AM.csv
MonthlyReport_20240404_05_20_42_AM.csv
How can I add filter to only pick up the latest reports (ONLY file name starting with Report_ & FinalReport_) for me to copy to a different folder. Due to number of historical reports "List files in folders" is taking 20+ mins to run.
Is there a quick way to avoid looping through all the reports and get the copy latest Report_ & FinalReport_ reports?
Many thanks in advance.
Mitesh
