Rename files by reformatting date

Bulk Rename Utility How-To's

Rename files by reformatting date

Postby SWRUNDLE-EDWARDS » Wed Dec 30, 2020 5:23 pm

Hi,
Newbie here - I've stumbled across this product whilst looking for an answer to a problem.

I have a large number of historically downloaded bank statements which are saved as "19 February 2017 Current Account" etc etc - I need to identify missing statements so want to save these in a YYMMDD Current Account so they will be in numerical order and I can easily spot any gaps.

Is this possible ?

I have a lot of files to reference so thought it worth an ask.

Many thanks and all the best for 2021
SWRUNDLE-EDWARDS
 
Posts: 1
Joined: Wed Dec 30, 2020 5:10 pm

Re: Rename files by date

Postby Admin » Thu Dec 31, 2020 1:58 am

Hi, make a copy of all files first just in case, then work on the copy.

First Pass
Replace January with -01-
Replace February with -02-
etc

This can be done using

Replace (3)
Replace: January|February|March .... December (etc up to December, using | as separator)
With: -01-|-02-|-03- .... |-12-

Select files to rename and rename.
All files will be in the following format:
19-02-2017 Current Account

Second Pass
Use RegEx (1) to rearrange the date.
Enable option "simple", then

Match : %1-%2-%3 %4 %5
Repalce: %3-%2-%1 %4 %5

Preview then select files to rename and rename.
Admin
Site Admin
 
Posts: 2351
Joined: Tue Mar 08, 2005 8:39 pm


Return to How-To