Rename multiple titles in series?

Luddite · 04-27-2020, 05:29 PM

Greetings and thanks in advance for any help you can provide.

I have a series of books that I previously had name in the following format - "<series name> <series #> - <title>", e.g. "Series 0001 - Title of book".

There are quite a few of them, and I'd like to remove the prefix <series name> <series #> so that I am just left with <title>, e.g. "Title of book".

Is this possible to do in Bulk Metadata editing using find/replace and some kind of expression or string?

theducks · 04-27-2020, 05:42 PM

Bulk mode MDE can do

Code:

<series name> <series #> - <title>", e.g. "Series 0001 - Title of book

NOT TESTED. Bulk mode has no Undo BACKUP before, verify the right side of the S&R looks 100%

Source: title mode is: Regular expression
search : .+?\s-\s(.+?)
replace with: \1 (no need to spec the dest. Mode is replace field

Decoded:
look for anything up to and including: space dash space (discarded)
Capture everything after that.
replace the title field with the capture

pdurrant · 04-27-2020, 05:47 PM

Yes, in the Search and Replace tab of the bulk metadata editing. You'll need to use the regular expression mode on the title field.

the search expression you'll need is something like

^[^-\d]+\d+_-_

and the replace field should be blank.

(The search expression says
^ -: match from the start of the field (well, line, but there's only one line in a title field)
[^-\d]+ : one or more characters that aren't a dash or a digit
\d+ : one or more numeric digits
_-_ : space dash space)

where the underscores are spaces. It will show you what the effect will be on the first ten titles.

pdurrant · 04-27-2020, 05:50 PM

If any of your actual titles include space dash space, then theducks' expression will delete up to the final space dash space, not the first one.

But mine might have undesired side effects too - I haven't spent very long looking at it.

04-27-2020, 05:29 PM	#1
Luddite Junior Member Posts: 9 Karma: 10 Join Date: Sep 2016 Device: Tab S6 - Moon+ Reader Pro	Rename multiple titles in series? Greetings and thanks in advance for any help you can provide. I have a series of books that I previously had name in the following format - "<series name> <series #> - <title>", e.g. "Series 0001 - Title of book". There are quite a few of them, and I'd like to remove the prefix <series name> <series #> so that I am just left with <title>, e.g. "Title of book". Is this possible to do in Bulk Metadata editing using find/replace and some kind of expression or string?

04-27-2020, 05:42 PM	#2
theducks Well trained by Cats Posts: 31,048 Karma: 60358908 Join Date: Aug 2009 Location: The Central Coast of California Device: Kobo Libra2,Kobo Aura2v1, K4NT(Fixed: New Bat.), Galaxy Tab A	Bulk mode MDE can do Code: <series name> <series #> - <title>", e.g. "Series 0001 - Title of book NOT TESTED. Bulk mode has no Undo BACKUP before, verify the right side of the S&R looks 100% Source: title mode is: Regular expression search : .+?\s-\s(.+?) replace with: \1 (no need to spec the dest. Mode is replace field Decoded: look for anything up to and including: space dash space (discarded) Capture everything after that. replace the title field with the capture

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Problem when using tag browser to rename series	JohnnyBook	Library Management	3	06-24-2018 04:22 PM
multiple titles	Starbird	Library Management	7	04-29-2016 01:43 AM
rename multiple ebook	Lauraq	Calibre	33	11-12-2013 11:02 AM
Kindle Annotations vs Plugboard rename Title with series initials/numbering	Gwen Morse	Devices	2	09-05-2011 12:58 PM
Rename series	theducks	Calibre	2	05-02-2010 08:44 PM

04-27-2020, 05:47 PM	#3
pdurrant The Grand Mouse 高貴的老鼠 Posts: 73,941 Karma: 315160596 Join Date: Jul 2007 Location: Norfolk, England Device: Kindle Oasis	Yes, in the Search and Replace tab of the bulk metadata editing. You'll need to use the regular expression mode on the title field. the search expression you'll need is something like ^[^-\d]+\d+_-_ and the replace field should be blank. (The search expression says ^ -: match from the start of the field (well, line, but there's only one line in a title field) [^-\d]+ : one or more characters that aren't a dash or a digit \d+ : one or more numeric digits _-_ : space dash space) where the underscores are spaces. It will show you what the effect will be on the first ten titles.

04-27-2020, 05:50 PM	#4
pdurrant The Grand Mouse 高貴的老鼠 Posts: 73,941 Karma: 315160596 Join Date: Jul 2007 Location: Norfolk, England Device: Kindle Oasis	If any of your actual titles include space dash space, then theducks' expression will delete up to the final space dash space, not the first one. But mine might have undesired side effects too - I haven't spent very long looking at it.

Advert