Incrementing Month name?

Advanced Renamer forum
#1 : 23/04-22 14:48
sashmo
Posts: 2
Prior to posting my question, I have searched the documentation and forums but couldn't find an answer to my question about incrementing month names, i.e.

I would like to add an incrementing month at the end of the file name:

National.Geographic.2016.01.pdf
National.Geographic.2016.02.pdf
National.Geographic.2016.03.pdf

to

National.Geographic.2016.01.January.pdf
National.Geographic.2016.02.February.pdf
National.Geographic.2016.03.March.pdf

and so on... something like

National.Geographic.2016.<Inc Nr:1>
to
National.Geographic.2016.<Inc Nr:1>.<what do I insert here???>

Thank you for your help!

sm
#2 : 23/04-22 15:33
sashmo
Posts: 2
Reply to #1:

In case someone is looking for a partial solution...
I have set up a "monthname.csv" with the names of 12 months and imported it

National.Geographic.2016.<Inc Nr:1>.<Csv:1>

However, every time I add a new batch of files

National.Geographic.2017.<Inc Nr:1>.<Csv:1>
or
National.Geographic.2018.<Inc Nr:1>.<Csv:1>
or some
filename.<Csv:1>.<Year:X>, etc

or any other set of files that I would like to add incrementally increasing month names I have to import the CSV again and again...

Please help!

sm
#3 : 24/04-22 10:06
David Lee
Posts: 1125
Easiest solution is to generate filenames with numerical dates only, as you suggest:

National.Geographic.2016.01.pdf
National.Geographic.2016.02.pdf
etc

Then use a List replace method with 12 entries as a look-up table to add the names of the months...

List replace....
Replace (01$) with \1.January
Replace (02$) with \1.February
...
Replace (12$) with \1.December

Check "Use regular expressions"

edited: 24/04-22 10:09