Add prefix alphabet to filename when filename contains month name in ascending order

Help & Support
1

Hello,

I have couple of files (12 per year) for monthly statements. The filenames contain month name and year name. However for a purpose I need the files to be sorted chronologically by month name order (which is not detected correctly by the file explorer)

Is there a way to add an alphabetical prefix to each filename based on the chronological order of the month.

So the filenames are as below currently (without prefix) in default alphabetical sorting

image

I need them to have the prefix alphabet added like (A_, B_,...) in the order of the months, so they appear and can be used by another program in sequential order, like below

image

I hope i was able to explain the query clear enough. Is there a script or an existing add-in that can achieve the desired result.

Thanks for your usual support.

2

Twelve Rename commands will get this done:

Rename PATTERN=jan* TO=A_Jan* IGNOREEXT
Rename PATTERN=feb* TO=B_Feb* IGNOREEXT
Rename PATTERN=mar* TO=C_Mar* IGNOREEXT
Rename PATTERN=apr* TO=D_Apr* IGNOREEXT
Rename PATTERN=may* TO=E_May* IGNOREEXT
Rename PATTERN=jun* TO=F_Jun* IGNOREEXT
Rename PATTERN=jul* TO=G_Jul* IGNOREEXT
Rename PATTERN=aug* TO=H_Aug* IGNOREEXT
Rename PATTERN=sep* TO=I_Sep* IGNOREEXT
Rename PATTERN=okt* TO=J_Okt* IGNOREEXT
Rename PATTERN=nov* TO=K_Nov* IGNOREEXT
Rename PATTERN=dec* TO=L_Dec* IGNOREEXT

Renaming to sortable dates ("2020-01") is not an option?

3

Hello,

So I understand I need to add these commands to custom user command from the below option and can make a toolbar button for it to process all files in the folder in focus, correct. ?

image

Renaming to sortable dates I am not sure will work but can try. I am using an Excel Add-In called RDBMerge. I need all bank statements to be merged in a single file for the whole year. The way RDBMerge picks the file is in alphabetical sequence, so to have correct monthly chronological sequence for the merged file, I need them prefixed alphabetically.

Thanks for your help.

4