Quote:
Originally Posted by unboggling
... Search for all books with the comma in authors ... Use Edit Metadata in Bulk, Search and Replace Tab, regular expression mode to switch elements around the comma:
Search field: authors
Search for: (.+), (.*)
Replace with: \2 \1
Look at the test results. ...
|
Hi unblogging, thank you for your greeting message.
I tried the bulk metadata edit approach using the search and replace parameters you suggested, and it worked great!
Per your caution on potential exceptions, the only additional steps that I took were:
a) first located and adjusted all authors names that contained more than one comma (I didn't know how to search for two commas in the Calibre search and so used a separate program outside of Calibre to list out all the author folder names shown in Windows Explorer and then used a character string test within Excel),
b) copied the metadata edit results to a test user-defined column prior to copying the results into the "author" field.
Thank you unboggling !