Hi there,
I have a couple of downloaded Excel files, and I want to choose 1 file to move to another folder.
Here're the Excel files and the process map & Downloads folder
First, I use Get Files to get all Excel files and it working
and the collection output
Now I want to Filter the latest Excel File. and choose the file xxx20.48.44 to work on. Can you please show me how I can do that? Note: the Excel file name is given by "excel-yy-mm-dd_time.xlsx", therefore, the Excel file name will be changed time by time. Is there any way I can achieve that? [I know the Filter Collection action with the "latest written" but it's not a good choice since I dont know how to do it and many files arrived at the same time, and I want to filter and pick the file by name. Thank you!
------------------------------
Mia Mikela
------------------------------
Hi @Mia Mikela
The most straight forward way to do this is simply loop the collection and use InStr to identify the correct file name which can look for a part of the name rather than the full name of the file. Create a loop through the files and use a decision stage to check the name using InStr, the query would read InStr([Files.Name],"13-01-2023")>0 if this is true then you use the action Move file if not then onto the next file name. If the file date is dynamic then you can use the date functions in place of a static value e.g. FormatDate(Today(),"dd.MM.yyyy") will give todays date.
------------------------------
Michael ONeil
Technical Lead developer
NTTData
Europe/London
------------------------------
