Bulk mode search and replace.
Select A of 1 series (magazine) then tap 'E'
Quote:
|
Gardens Illustrated, 2019 11
|
REGEX mode: Title field
(.+?),\s(\d{4})\s(\d{1,2})
Decoded: 3 captures. anything up to a comma, 4 digits of year, 102 digits of month (note range is not permitted. no 07-08, I use first)
BTW I would pad single digit months with leading 0 to keep a clean sort
Multiple passes
#1
Replace:
Dest series: \1
#2
Replace
dest series_index
\2.\3
The series is the same as the Magazine
the index is YYYY . MM no spaces
We CAN NOT clean the title (at least very much)
Every entry MUST be different
Note For
Series Indexes, you need to convert named months to Digits to have them sort in proper order. The title can stay 2009 Nov (Nov 2009)