Title included with Author

CarlM · 07-25-2014, 11:16 AM

Hi,

I recently had 24,000 epub books given to me. I have a Kindle. I loaded them into Calibre but a large number of them, a few thousand, have the title and/or series in the author column along with the author. When I try to download the metadata it doesn't find the book in the search until I delete everything after the author.

Example: Pratchett, Terry - Discworld 15 - Men At Arms

Is there any way to bulk edit the author column and remove everything after the - symbol.

Many Thanks

Carl

eschwartz · 07-25-2014, 11:34 AM

Quote:

Originally Posted by CarlM

Hi,

I recently had 24,000 epub books given to me. I have a Kindle. I loaded them into Calibre but a large number of them, a few thousand, have the title and/or series in the author column along with the author. When I try to download the metadata it doesn't find the book in the search until I delete everything after the author.

Example: Pratchett, Terry - Discworld 15 - Men At Arms

Is there any way to bulk edit the author column and remove everything after the - symbol.

Many Thanks

Carl

Select all the books and click Edit Metadata. This will open Bulk Metadata Edit -- the last tab allows you to use regex Search and Replace on metadata fields.

CarlM · 07-25-2014, 11:52 AM

Thanks for the response.

I understand how to search and replace specific symbols or something in parentheses but how do I get the bulk edit to delete everything from the dash symbol.

Example: Modesitt, LE - Corean Chronicles 5

How would I get it to delete - Corean Chronicles 5 without having to type in the exact words and number when every book is different?

eschwartz · 07-25-2014, 11:59 AM

Search:

Code:

([^-]*) - .*

Replace:

Code:

\1

CarlM · 07-25-2014, 01:26 PM

Nothing happened. I copied your code and pasted it.

eschwartz · 07-25-2014, 05:59 PM

Are you using regular expressions mode?

http://manual.calibre-ebook.com/meta...ch-and-replace

CarlM · 07-26-2014, 07:52 AM

I wasn't but I am now. Works great. Thanks very much for your help. Greatly appreciated.

Carl

eschwartz · 07-27-2014, 01:50 AM

Quote:

Originally Posted by CarlM

I wasn't but I am now. Works great. Thanks very much for your help. Greatly appreciated.

Carl

Happy to help.

07-25-2014, 11:16 AM	#1
CarlM Junior Member Posts: 7 Karma: 10 Join Date: Jul 2014 Device: Kindle	Title included with Author Hi, I recently had 24,000 epub books given to me. I have a Kindle. I loaded them into Calibre but a large number of them, a few thousand, have the title and/or series in the author column along with the author. When I try to download the metadata it doesn't find the book in the search until I delete everything after the author. Example: Pratchett, Terry - Discworld 15 - Men At Arms Is there any way to bulk edit the author column and remove everything after the - symbol. Many Thanks Carl

07-25-2014, 11:59 AM	#4
eschwartz Ex-Helpdesk Junkie Posts: 19,421 Karma: 85400180 Join Date: Nov 2012 Location: The Beaten Path, USA, Roundworld, This Side of Infinity Device: Kindle Touch fw5.3.7 (Wifi only)	Search: Code: ([^-]) - . Replace: Code: \1

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Changing from Title-Author to Author - Title	Amalthia	Calibre	17	01-22-2017 11:20 PM
Using plugboards to add series only when not already included in the title	antarex	Library Management	11	04-12-2013 01:22 PM
Switching of title and author	Lotus Eater	Calibre	1	02-18-2011 02:23 AM
How to Get Blog Author Names Included?	LaneLester	Recipes	0	01-22-2011 12:41 PM
Title and author on Kindle DX	barth90	Calibre	0	05-17-2010 05:35 PM

07-25-2014, 11:52 AM	#3
CarlM Junior Member Posts: 7 Karma: 10 Join Date: Jul 2014 Device: Kindle	Thanks for the response. I understand how to search and replace specific symbols or something in parentheses but how do I get the bulk edit to delete everything from the dash symbol. Example: Modesitt, LE - Corean Chronicles 5 How would I get it to delete - Corean Chronicles 5 without having to type in the exact words and number when every book is different?

07-25-2014, 01:26 PM	#5
CarlM Junior Member Posts: 7 Karma: 10 Join Date: Jul 2014 Device: Kindle	Nothing happened. I copied your code and pasted it.

07-25-2014, 05:59 PM	#6
eschwartz Ex-Helpdesk Junkie Posts: 19,421 Karma: 85400180 Join Date: Nov 2012 Location: The Beaten Path, USA, Roundworld, This Side of Infinity Device: Kindle Touch fw5.3.7 (Wifi only)	Are you using regular expressions mode? http://manual.calibre-ebook.com/meta...ch-and-replace

07-26-2014, 07:52 AM	#7
CarlM Junior Member Posts: 7 Karma: 10 Join Date: Jul 2014 Device: Kindle	I wasn't but I am now. Works great. Thanks very much for your help. Greatly appreciated. Carl

Advert

Advert