Hello,
i am using Directory tool to list all my input files then will use dynamic input tool to select my specific file for specific task. on my directory tool there are around 10-15 .xlsx files and out of these many files how can i pick this one file Jan.xlsx from following list because this file name with month will change in every month and all other file will replace with same name. i mean on next month Jan 31 file will replace with Feb 27 file so is there any way so i can pick the file by first three letter from month.
File Name |
Red.xlsx |
Green.xlsx |
Blue.xlsx |
Jan 31.xlsx |
Black.xlsx |
white.xlsx |
Purple.xlsx |
Orange.xlsx |
Aug 30.xlsx |
Light Green.xlsx |
Yellow.xlsx |
Thank you
Kauser
Solved! Go to Solution.
Will it always be 3 letter followed by 2 digits? If so, this should work to Filter the list:
Regex_Match([File Name], '^\w+\s\d{2}\.xlsx')