Incrementing Month name?
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
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
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
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
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"
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"