07-20-2020, 07:28 PM | #1 |
Enthusiast
Posts: 25
Karma: 10
Join Date: Jun 2012
Device: K3 Wifi No Ads/K4 Wifi ads
|
Multiple Authors with wrong separator
I am using Calibre 3.48.
My problem: I have several authors for one book that are separated by "," instead of by "&". I am looking for an easy way to change the separator for over 500 books now in Calibre. EXAMPLE #1: FROM: Tom Mix, Rex Reed, Pete Sampras - [Series 01] - I Love This Book TO: Tom Mix & Rex Reed & Pete Sampras - [Series 01] - I Love This Book EXAMPLE #2: FROM: Tom Mix, Rex Reed, Pete Sampras - I Love This Book TO: Tom Mix & Rex Reed & Pete Sampras - I Love This Book Not sure if I need a plug in or some other method of achieving this within Calibre. Thanks in advance for your help. |
07-20-2020, 09:35 PM | #2 | |
Well trained by Cats
Posts: 29,812
Karma: 54830978
Join Date: Aug 2009
Location: The Central Coast of California
Device: Kobo Libra2,Kobo Aura2v1, K4NT(Fixed: New Bat.), Galaxy Tab A
|
Quote:
Select all the books with the SAME 3 wrong: Tap 'E" (bulk mode Metadata edit): Enter/edit the list ( copy the wrong authors field to the clipboard Before Bulk mode, paste into Authors) and replace the , with & ( remember to tick auto set author sort) OK |
|
07-21-2020, 01:02 PM | #3 |
Enthusiast
Posts: 25
Karma: 10
Join Date: Jun 2012
Device: K3 Wifi No Ads/K4 Wifi ads
|
Thank you for the reply on how to convert , to &.
QUESTION: Is there an automated way to do the same thing. Have the program review all the authors and convert any comma to a <space>& If not, I will do as you suggested in your reply. Many thanks for the response. |
07-21-2020, 01:23 PM | #4 | |
Well trained by Cats
Posts: 29,812
Karma: 54830978
Join Date: Aug 2009
Location: The Central Coast of California
Device: Kobo Libra2,Kobo Aura2v1, K4NT(Fixed: New Bat.), Galaxy Tab A
|
Quote:
Sometimes the old eye is better than just letting Auto run amuck . Hopefully this is a rare occurrence and you only need to do a few times |
|
07-21-2020, 02:04 PM | #5 | |
Grand Sorcerer
Posts: 11,742
Karma: 6997045
Join Date: Jan 2010
Location: Notts, England
Device: Kobo Libra 2
|
Quote:
However, as theducks says, you could end up with a worse mess. What happens if the example is not "Joe Blogs, Some Person" but is instead "Blogs, Joe, Person, Some"? Doing it mechanically will turn this example into "Blogs & Joe & Person & Some". You would then need to fix these authors, probably using the Manage Authors dialog to merge them. |
|
07-21-2020, 10:29 PM | #6 |
Guru
Posts: 724
Karma: 228142
Join Date: Sep 2017
Location: Argentina
Device: moon+ reader, kindle paperwhite
|
With Division of multiple author names, it should work
Preference / settings ID: authors_split_regex By default, caliber splits a text containing multiple authors into the characters "&" and the words "and" and "with". You can customize how division is done by changing the regular expression below. Texts are divided into any position that matches the expression, in addition to "&". Sorry I uploaded the photos in Spanish |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Wrong author sort for brother authors | rebl | Library Management | 19 | 07-22-2019 04:41 PM |
Multiple Authors | pdurrant | Calibre | 33 | 12-21-2017 12:37 PM |
Touch Wrong order of authors and books in series | cosmicbite | Kobo Reader | 1 | 06-07-2015 08:37 PM |
Multiple authors | AlexBell | Upload Help | 2 | 04-17-2015 01:56 AM |
Authors smart list for books with multiple authors -bug? | SergeyGomanyuk | Marvin | 1 | 03-29-2014 04:14 AM |