SOLVED
picking monthly file from directory tool
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
kauser
8 - Asteroid
‎08-29-2024
12:44 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
Labels:
- Labels:
- Developer
- Developer Tools
- Documentation
1 REPLY 1
18 - Pollux
‎08-29-2024
12:54 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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')
