Regex

[AS]

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

[atcodedog05 · Accepted solution]

Hi @AS 

Here is how you can do it.

Workflow:

Hope this helps : )

[atcodedog05]

Happy to help : ) @AS 

Cheers and have a nice day!