Copy part of Album to Year

Hi all, I promise I searched all over and tried a bunch of things before coming here :slight_smile:

I'm trying to take part of the album name and use it for the year field.

i.e. All of the albums are in this format 1999-12-31 - Big Cypress Seminole Indian Reservation - Big Cypress, FL . The date followed by space - space Location. Id like to only pull the date out of here and add it to the year tag field, can anyone help me figure out how to build the Action for this to happen?

For clarity, Id like 1999-12-31 from the above example to be set as the year.

Thanks so much for any help!

You could try an action of the type "Format value"
Format string: $regexp('1999-12-31 - Big Cypress Seminole Indian Reservation - Big Cypress, FL .',(.*?) - .*,$1)

Replace the example string with the source field reference.
Just a note: According to standard, YEAR has only 4 digits. If you want to store longer dates, think about using RELEASETIME