I will play with this a bit, but my RegEx-fu is weak.
We may be making this a bit more complex than necessary. I am using the series_index to put the magazines in order, but if the replace in the title field were simply sequential, (xxxx-01, xxxx-02 etc.) it would be more than satisfactory. (e.g. I pick the magazines for the year 2008, make sure that they are in order, and then apply a replace to the title field such as: National Geographic 2008-xx, with the xx being a series of numbers 01, 02, 03...)
|