View Single Post
Old 12-13-2012, 08:18 AM   #5
Adoby
Handy Elephant
Adoby ought to be getting tired of karma fortunes by now.Adoby ought to be getting tired of karma fortunes by now.Adoby ought to be getting tired of karma fortunes by now.Adoby ought to be getting tired of karma fortunes by now.Adoby ought to be getting tired of karma fortunes by now.Adoby ought to be getting tired of karma fortunes by now.Adoby ought to be getting tired of karma fortunes by now.Adoby ought to be getting tired of karma fortunes by now.Adoby ought to be getting tired of karma fortunes by now.Adoby ought to be getting tired of karma fortunes by now.Adoby ought to be getting tired of karma fortunes by now.
 
Adoby's Avatar
 
Posts: 1,001
Karma: 3512570
Join Date: Dec 2009
Location: Southern Sweden, far out in the quiet woods
Device: Ubuntu Linux, Cybook Opus, Motorola Xoom with Mantano Premium
Calibre has great support for search and replace using "Regular Expressions". This is what you use to populate series and series no from the authors field, and to clean up the authors field.

Before you start, make sure that you have a good backup of all books, and that you are comfortable with restoring the backup if needed. There is no undo here. None! You have been warned...

The procedure is done in four steps.

1. Identify and select all books with the same naming structure.
2. Create a RegExp to match the series part of the current authors field. Copy the match into the series field.
3. Create a RegExp to match the series number part of the current authors field. Copy the match into the series no field.
4. Create a RegExp to match the actual authors part of the authors field. Replace the current authors field with the match.

Done!

There are several threads here on this and similar topics. Also about RegExp. Here is one example that may help a little.

http://www.mobileread.com/forums/sho...d.php?t=192415

Last edited by Adoby; 12-13-2012 at 09:39 PM.
Adoby is offline   Reply With Quote