Convert Amazon Series names in Title to Calbre Series

ian-and-penny · 09-04-2017, 04:44 AM

Is it possible to convert book titles (downloaded from Amazon) that contain series data to contain the title only, and populate the series field with the series info?

For example I would like the book title "Wired In (Paradise Crime Book 1)" to be "Wired in Paradise" and the series column to be populated with "Paradise Crime [1]"

theducks · 09-04-2017, 10:36 AM

Quote:

Originally Posted by ian-and-penny

Is it possible to convert book titles (downloaded from Amazon) that contain series data to contain the title only, and populate the series field with the series info?

For example I would like the book title "Wired In (Paradise Crime Book 1)" to be "Wired in Paradise" and the series column to be populated with "Paradise Crime [1]"

Look at the Bulk mode (for 2 or more books) of the Metadata Editor's Search and Replace Tab.

It will take 2+ passes: (I never got series +series_index to work in a single pass)
1) Copies the Series info to the Series Column

I crop out the 'Book'
2) clean up the title (discard the original series stuff)

something like this search title REGEX
Be sure to backup your Library. Bulk mode has no UNDO
Search Title

Code:

 (.+?)\s\((.+?) Book (\d+)\)

Replaces:
Series: \2
series_index: \3
Title: \1

A couple of other crops/edits I regularly do:
I also crop:
'Series'

'A'
Plurals: Mysteries -> Mystery (this is just one book of many

)

JSWolf · 09-04-2017, 10:51 AM

The problem is that a lot of the time, numbers are not used. And sometimes, you'll find the word of the number used.

(Artemis Fowl, Book One)
(The Four Streets Trilogy)

Are two examples.

theducks · 09-04-2017, 12:00 PM

Quote:

Originally Posted by JSWolf

The problem is that a lot of the time, numbers are not used. And sometimes, you'll find the word of the number used.

(Artemis Fowl, Book One)
(The Four Streets Trilogy)

Are two examples.

Perfect examples of Why a single, bulk solution is not recommended.
Some lend themselves to semi-automated repairs (saved S&R Searches)
some, like you show, just need TLC by hand

JSWolf · 09-04-2017, 03:09 PM

What I do is the series info by hand. It just works better.

09-04-2017, 04:44 AM	#1
ian-and-penny Junior Member Posts: 1 Karma: 10 Join Date: Sep 2017 Device: Kindle Paperwhite	Convert Amazon Series names in Title to Calbre Series Is it possible to convert book titles (downloaded from Amazon) that contain series data to contain the title only, and populate the series field with the series info? For example I would like the book title "Wired In (Paradise Crime Book 1)" to be "Wired in Paradise" and the series column to be populated with "Paradise Crime [1]"

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Can I append the series info from the 'series' column onto the title?	michaeltoye	Calibre	2	06-30-2017 02:35 AM
RegEx for Series - Series No - Title	elizanoloo	Library Management	6	08-22-2016 03:03 PM
Plugboard "Metadata: Show series [series index] - title as title (Kindle)"	Deep Cover	Library Management	6	11-30-2012 05:17 PM
Convert book with Series in Title?	CuriousGuy	Library Management	4	06-21-2012 12:59 AM
Command Line problems: ebook-convert, ebook-meta with tags: --series, --series-index	omnivorous	Calibre	4	11-07-2010 02:42 PM

09-04-2017, 10:51 AM	#3
JSWolf Resident Curmudgeon Posts: 74,015 Karma: 129333114 Join Date: Nov 2006 Location: Roslindale, Massachusetts Device: Kobo Libra 2, Kobo Aura H2O, PRS-650, PRS-T1, nook STR, PW3	The problem is that a lot of the time, numbers are not used. And sometimes, you'll find the word of the number used. (Artemis Fowl, Book One) (The Four Streets Trilogy) Are two examples.

09-04-2017, 03:09 PM	#5
JSWolf Resident Curmudgeon Posts: 74,015 Karma: 129333114 Join Date: Nov 2006 Location: Roslindale, Massachusetts Device: Kobo Libra 2, Kobo Aura H2O, PRS-650, PRS-T1, nook STR, PW3	What I do is the series info by hand. It just works better.

Advert

Advert