Register Guidelines E-Books Search Today's Posts Mark Forums Read

Go Back   MobileRead Forums > E-Book Software > Calibre > Library Management

Notices

Reply
 
Thread Tools Search this Thread
Old 09-04-2017, 04:44 AM   #1
ian-and-penny
Junior Member
ian-and-penny began at the beginning.
 
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]"
ian-and-penny is offline   Reply With Quote
Old 09-04-2017, 10:36 AM   #2
theducks
Well trained by Cats
theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.
 
theducks's Avatar
 
Posts: 22,745
Karma: 23579576
Join Date: Aug 2009
Location: (The original) Silicon Valley, USA
Device: K4NT, Galaxy Tab A, Kobo Aura2
Quote:
Originally Posted by ian-and-penny View Post
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 )
theducks is offline   Reply With Quote
Advert
Old 09-04-2017, 10:51 AM   #3
JSWolf
Resident Curmudgeon
JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.
 
JSWolf's Avatar
 
Posts: 52,493
Karma: 47532967
Join Date: Nov 2006
Location: Roslindale, Massachusetts
Device: Kobo Aura H2O, Sony PRS-650, Sony PRS-T1, nook STR, iPad 4, iPhone 5
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.
JSWolf is offline   Reply With Quote
Old 09-04-2017, 12:00 PM   #4
theducks
Well trained by Cats
theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.
 
theducks's Avatar
 
Posts: 22,745
Karma: 23579576
Join Date: Aug 2009
Location: (The original) Silicon Valley, USA
Device: K4NT, Galaxy Tab A, Kobo Aura2
Quote:
Originally Posted by JSWolf View Post
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
theducks is offline   Reply With Quote
Old 09-04-2017, 03:09 PM   #5
JSWolf
Resident Curmudgeon
JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.
 
JSWolf's Avatar
 
Posts: 52,493
Karma: 47532967
Join Date: Nov 2006
Location: Roslindale, Massachusetts
Device: Kobo Aura H2O, Sony PRS-650, Sony PRS-T1, nook STR, iPad 4, iPhone 5
What I do is the series info by hand. It just works better.
JSWolf is offline   Reply With Quote
Advert
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Forum Jump

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


All times are GMT -4. The time now is 09:44 AM.


MobileRead.com is a privately owned, operated and funded community.