It may be too late now, but...
The authors in calibre are separated with &. There is nothing you can do about that. But you can switch the titles from the author field to the title field, and replace "&" in the titles with ";". Not perfect. And backups are good to make in advance.
1. Add a custom column so you can keep track of the problem books. Perhaps "fixit".
2. Set #fixit to yes for all problem books, and restrict the book list to books to fix.
3. Do a bulk metadata edit to swap author and title fields.
4. Do a bulk metadata edit and search and replace " &" in the titles with ";"
5. Review and remove the custom column "fixit" if all seems fine.
Problems:
If there were some titles that actually had a legit "&" in the title, then that has now changed to ";".
|