Reformatting Date in file name

[matix1003]

I am trying to rename file dates, but have had no luck.. The final date format needs to be YYYY-MM-DD

Original:
Hawaii.Oahu.20.08.30.1080p.mp4

Changed to:
Hawaii - Oahu - 2020-08-30 - 1080p.mp4

Thanks!

[therube]

1:RegEx

Code: Select all

Match:  (.*?)\.(\d\d).(\d\d).(\d\d)(.*)
Replace:  \1 - 20\2-\3-\4 -\5


3:Replace

Code: Select all

Replace:  .
With: "" (don't enter anything, i.e. not a physical "")


Match anything, non-greedy, up to a .
Match 2 digits
Match 2 digits
Match 2 digits
Match everything else

Reformat, sticking a physical "20" as the preface to the year.
(That also assumes no 19xx years.)

[matix1003]

Thanks for the response, I am very new to Bulk Rename Utility. It didn't seem to work...

The closest that I can get

RegEx

Match: (.*)(\d\d)(.\d\d).(\d\d)(.*)?

Replace: \120\2\3-\4\5

but my output is Hawaii.Oahu.2020.08-30.1080p.mp4

can't get "-" between year and get rid if the periods between Hawaii and Oahu and 2020 and 1080p

[matix1003]

bump

[therube]

1:RegEx

Code: Select all

Match:  (.*?)\.(\d\d).(\d\d).(\d\d)(.*)
Replace:  \1 - 20\2-\3-\4 -\5


3:Replace

Code: Select all

Replace:  .
With:  <sp> (that is a physical space, not <sp>)

Code: Select all

Hawaii.Oahu.20.08.30.1080p.mp4   
   -> Hawaii Oahu - 2020-08-30 - 1080p.mp4
Hawaii.20.08.30.1080p.mp4
   -> Hawaii - 2020-08-30 - 1080p.mp4


(Other thread, viewtopic.php?f=4&t=6120.)