Thanks for putting this together. The author trick is especially helpful. I've always just fixed the authors by hand, but that can get tedious.
Something to be aware of: Book titles may have a legitimate period or dash in them, and authors may have a legitimate comma, for instance if their name includes a degree. ALWAYS inspect each book title/author visually before selecting it to be included in the search/replace. You don't want to turn "John Smith, MD" into "MD John Smith."
I would recommend doing the search/replace in small to medium batches. If you've spent several minutes CTRL-clicking on hundreds of books as you've identified the ones to fix, it can be annoying to accidentally click on another book and lose your selection. Better to spend only a few seconds selecting books, running the replace, then repeating the process multiple times. If you save the searches, you can always come back to them in just a couple of clicks.
|