Reformat a date string into an actual date

Post any Bulk Rename Utility support requirements here. Open to all registered users.

Reformat a date string into an actual date

Postby icursmart » Sun Mar 31, 2019 2:58 pm

I've have hundreds of videos that I saved the date within the file name without separators (mmddyyy), e.g. Webinar Jack Welch 12241999.wmv
Unfortunately, I'm unable to sort these files by date. I want to now add a separator or ideally, convert to an actual date. I just can seem to figure this one out.

Below are some sample files:
Spotlight Jon Snow 01222018.wmv
Clubhouse Mary Jane Watson 03222015.wmv
Webinar Jack Welch 12241999.wmv

What I want is either:
Spotlight Jon Snow 01-22-2018.wmv OR
Spotlight Jon Snow January 22 2018.wmv

Clubhouse Mary Jane Watson 03-22-2015.wmv OR
Clubhouse Mary Jane Watson March 22 2015.wmv

Webinar Jack Welch 12-24-1999.wmv OR
Webinar Jack Welch December 24-1999.wmv

Since the "dot" is a unique symbol in every file, I was hoping to use a search and replace to find the string of numbers BEFORE the "dot" and convert that string of numbers to the format of my choosing. Just can't seem to figure out how to make this work.

Can anyone help me with this one. Thanks!
icursmart
 
Posts: 2
Joined: Sun Mar 31, 2019 2:27 pm

Re: Reformat a date string into an actual date

Postby therube » Sun Mar 31, 2019 10:34 pm

For the dash method, try:

1:RegEx
Code: Select all
Match:  (.*)(\s\d\d)(\d\d)(\d\d\d\d)
Replace:  \1\2-\3-\4



For the "word" method, JavaScript Renaming would do it.
(Actual means are beyond me.)
therube
 
Posts: 1314
Joined: Mon Jan 18, 2016 6:23 pm

Re: Reformat a date string into an actual date

Postby icursmart » Tue Apr 02, 2019 3:39 pm

Thank you! It worked perfectly.
icursmart
 
Posts: 2
Joined: Sun Mar 31, 2019 2:27 pm


Return to BRU Support