09-04-2017, 04:44 AM | #1 |
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]" |
09-04-2017, 10:36 AM | #2 | |
Well trained by Cats
Posts: 29,944
Karma: 55705602
Join Date: Aug 2009
Location: The Central Coast of California
Device: Kobo Libra2,Kobo Aura2v1, K4NT(Fixed: New Bat.), Galaxy Tab A
|
Quote:
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+)\) 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 ) |
|
Advert | |
|
09-04-2017, 10:51 AM | #3 |
Resident Curmudgeon
Posts: 74,537
Karma: 129670952
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, 12:00 PM | #4 | |
Well trained by Cats
Posts: 29,944
Karma: 55705602
Join Date: Aug 2009
Location: The Central Coast of California
Device: Kobo Libra2,Kobo Aura2v1, K4NT(Fixed: New Bat.), Galaxy Tab A
|
Quote:
Some lend themselves to semi-automated repairs (saved S&R Searches) some, like you show, just need TLC by hand |
|
09-04-2017, 03:09 PM | #5 |
Resident Curmudgeon
Posts: 74,537
Karma: 129670952
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 | |
|
|
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 |