The ultimate magic tool would...
Author: I thought about perhaps matching a controllable number of characters in the sirname and grouping but to simplify, it would probably need to just match the sirname. There will be lots of false positives but faster than searching through a monster list.
Publisher - Match first word - display any non-matches. In your example, the first 3 would come up as matches, all 3 Ballantine, Both Bantam, etc. Most of the non-conformity I see in publishers is someone truncating their name in metadata or the company expanding it later.
Forget I mentioned series - I only have about 100 of those - it'll be faster to do it by hand probably.
Working with the Manage authors, tags, etc. is ok for some tasks but seems very limited
|