View Single Post
Old 07-21-2020, 02:04 PM   #5
chaley
Grand Sorcerer
chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.
 
Posts: 12,449
Karma: 8012886
Join Date: Jan 2010
Location: Notts, England
Device: Kobo Libra 2
Quote:
Originally Posted by Ptaker View Post
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>&
Yes, using Bulk Edit Search & Replace (regular expression mode). Search for authors containing ", " and replace it with &.

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.
chaley is offline   Reply With Quote