Reformatting Dates in Title Field

Support
1

Hello, I have hundreds of files where the TITLE field is the name followed by the date in MMM DD, YYYY format. Is there a way to change the format to YYYY-MM-DD and move it to beginning (e.g. interesting title - Jan 10, 2020 to 2020-01-10 - interesting title)?

Any help will be appreciated!

2

Try an action of the type "format value" for TITLE
Format string: $replace($regexp(%title%,'(.*) - (\w+) (\d\d), (\d\d\d\d)',$4-$2-$3 - $1),Jan,01,Feb,02)
You would have to complete the list of months.

3

Just what I needed, tysm!