This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Hi Experts,
Hope you all are doing great.
I need your help picking the multiple files but the only condition is if there is a file exist multiple time with the same name then I need to select the oldest file. I'm also thinking may be we can do this by using regex but could not figure it out how.
Example-
F_000AAA_20220118T001157180_DA.xlsx
1. F_000AAA- Name of the file
2. (Attaching image to explain second part)
3. DA is fixed.
Name | Decision |
F_000AAA_20220118T001157180_DA.xlsx | Approved |
F_000BBB_20210310T093555697_DA.xlsx | Approved |
F_000BBB_20210311T163054897_DA.xlsx | NA |
F_000BBB_20210311T163656587_DA.xlsx | NA |
F_000CCC_20210715T140732173_DA.xlsx | NA |
F_000CCC_20210715T030452473_DA.xlsx | Approved |
F_000DDD_20210715T030452473_DA.xlsx | Approved |
Solved! Go to Solution.
Happy to help : ) @AS
Cheers and have a nice day!