Hi -- I have a mental block when it comes to regex and can't figure this out for the life of me.
I'd like to be able to choose a group of files in the finder and then run a KM macro to change their names based on user input and the current month:
Existing file names:
10536-MARBLE-Jun-BC-77.txt
10536-SLATE-Jun-BC-72.txt
10536-COPPER-Jun-BC-58.txt
Desired file names:
10987-MARBLE-Jul-BC-77.txt
10987-SLATE-Jul-BC-72.txt
10987-COPPER-Jul-BC-58.txt
I'd input the new code number (10987 in the example) and the macro would calculate the date. Delimiter in the file name is always a dash.
I've been looking at SPLIT PATH to get the file name, but then I get caught up in the correct regex to split and substitute.
Any help would be much appreciated.
Thank you,
Randy