View Single Post
Old 02-18-2013, 05:52 AM   #19
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,737
Karma: 26785684
Join Date: Dec 2009
Location: Southern Sweden, far out in the quiet woods
Device: Samsung Galaxy Tab S8 Ultra
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 ";".
Adoby is offline   Reply With Quote