Extract Pubdate from imported Magazines
I have a slew of periodicals that I've imported that are in the general format of
Title: Title - YYYY Mmm
(for instance MagPi - 2017 October)
I'm trying to figure out how (if there's a way) to use Edit Metadata In Bulk to parse the titles, extract the date info (via RegEx) and insert it into the PubDate field for each title.
Is this possible? I've had zero luck so far with a wide variety of options on the Search and replace dialog in Edit meta information.
Thanks!
|