Replace periods until i get to Dates 2020.02.11?

Advanced Renamer forum
#1 : 11/02-20 14:33
Damien Lee Benoit
Posts: 3
I have lots and LOTS of tv shows and all of them have a period between each word in the titles and also the subtitles (for late night episodes - the guest of the episode) and after that there is mostly Season # then episode # or it would be air date, mostly trying to figure out how to quickly get around the air date which is normally separated like 2020.02.11
Typical file structure:
Lights.Out.with.David.Spade.2020.02.06.mkv

I really would like that get them all to be

Lights Out With David Spade - 02-06.mkg

Is there a way to replace all periods until it finds a date area and then change peirod point to - or something else. not sure what id rather, i just want to get past the replace all periods to a space until it gets to the numbers part. Possible?
#2 : 11/02-20 17:56
David Lee
Posts: 1125
Try using a List replace method with 3 entries:

1) Replace "\d\K\." with: "-"
2) Replace "\." with: space
3) Replace " (?=\d)" with: " - "

Use regular expressions
Don't include the quotation marks

Note that the third line will insert a hyphen before any space followed by a decimal digit - so it will misbehave if any of the words in the title start with a number

edited: 12/02-20 09:14