RegEx Assistance Needed

thenning

Hi everyone!  I'm very new to using RegEx and cannot seem to figure out how to accomplish the following with these file names from the Directory tool:

1. Only looking to pull in the .csv files with the naming convention of CPSC_Contract_Info_YYYY_MM.csv or CPSC_Enrollment_Info_YYYY_MM.csv (don't need any that are labeled as "old", etc.)
2. Want to change the underscore in between YYYY_MM to a hash mark (YYYY-MM)
3. Isolate YYYY-MM in its own column

Any assistance would be greatly appreciated.  Thanks!

File Names.xlsx

Luke_C

Hi @thenning 

Here's some examples:

Filter files: 

REGEX_Match([FileName], 'CPSC_Contract_Info_\d{4}_\d{2}.csv')
OR
REGEX_Match([FileName], 'CPSC_Enrollment_Info_\d{4}_\d{2}.csv')

Replace underscore: 

REGEX_Replace([FileName], '(.*\d{4})(_)(\d{2}.*)','$1-$3')

Isolate yyyy-mm:

REGEX_Replace([FileName], '.*(\d{4}.\d{2}).*','$1')

New Workflow4.yxmd