Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

picking monthly file from directory tool

kauser
8 - Asteroid

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 

1 REPLY 1
alexnajm
17 - Castor
17 - Castor

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')

Labels