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!