I own a Kindle 3, and used a metadata plugboard to add the series and number to the title on the Kindle, in the format Series - [00] - Title, when adding from Calibre.
I recently had a HDD failure and lost my calibre install - being left with the books on the Kindle from which to recover. I have connected the Kindle and added the books from there to the library on a fresh install of Calibre, but all the books are added with the titles being as above, and with the series and number fields unpopulated.
Is there a way to extract this information from the title field (removing it in the process) and add it to the series and number fields in a bulk fashion?
Any advice is greatly appreciated - I would rather not have to do this by hand on 100s of books. I am also well aware that in future I should back up my Calibre install elsewhere.
