delete multiple caracters in metadata

imans314 · 11-23-2013, 05:05 PM

I have al lot of books of wich I would like to delete the first coupl of caracters.

In series is says now: Doctor Who - Target Novelisations - 019
I would like ik to be: Target Novelisations - 019

With replacing I can delete the text but not the numbers, they change every book.

Who can help me?

Adoby · 11-23-2013, 05:18 PM

You can use bulk edit metadata and regular expressions to search and replace.

Search the title for

^(.*) - (.*) - (.*)$

And replace with \2. That will give you just the name of the book without series name or series index.

Before you do that you can also replace the series field with \1 and series index with \3.

Each set of parentheses creates a group that match a specific part of the title. Between the groups are the separators. In this case " - ". And you can refer to each group by the order of appearance.

\1 is the series name, "Doctor Who".
\2 is the actual title, "Target Novelisations".
\3 is the series index, "019".

^ and $ are used to specify start of the line and end of the line of text.

Regular expressions are very good to know. And extremely useful for most computer users, not only calibre users.

imans314 · 11-23-2013, 05:52 PM

Thanx, tha works. :-)

11-23-2013, 05:05 PM	#1
imans314 Enthusiast Posts: 45 Karma: 10 Join Date: Jul 2012 Device: sony prs-t1	delete multiple caracters in metadata I have al lot of books of wich I would like to delete the first coupl of caracters. In series is says now: Doctor Who - Target Novelisations - 019 I would like ik to be: Target Novelisations - 019 With replacing I can delete the text but not the numbers, they change every book. Who can help me?

11-23-2013, 05:18 PM	#2
Adoby Handy Elephant Posts: 1,737 Karma: 26785684 Join Date: Dec 2009 Location: Southern Sweden, far out in the quiet woods Device: Samsung Galaxy Tab S8 Ultra	You can use bulk edit metadata and regular expressions to search and replace. Search the title for ^(.) - (.) - (.)$ And replace with \2. That will give you just the name of the book without series name or series index. Before you do that you can also replace the series field with \1 and series index with \3. Each set of parentheses creates a group that match a specific part of the title. Between the groups are the separators. In this case " - ". And you can refer to each group by the order of appearance. \1 is the series name, "Doctor Who". \2 is the actual title, "Target Novelisations". \3 is the series index, "019". ^ and $ are used to specify start of the line and end of the line of text. Regular expressions are very good to know. And extremely useful for most computer users, not only calibre users. Last edited by Adoby; 11-23-2013 at 05:29 PM.*

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
epub file to mobi, but some caracters appear as question marks	abatsukh	Conversion	13	01-28-2021 11:20 PM
Delete multiple books?	Chapter One	Barnes & Noble NOOK	3	11-15-2013 12:23 PM
Aura HD Cannot delete multiple shelves	RZetlin	Kobo Reader	1	11-03-2013 10:52 AM
Delete book from edit Metadata?	crazyken	Library Management	2	08-04-2011 02:41 AM
Content Highlight and delete multiple files?	runningwithbulls	Amazon Kindle	9	10-21-2010 11:23 AM

11-23-2013, 05:52 PM	#3
imans314 Enthusiast Posts: 45 Karma: 10 Join Date: Jul 2012 Device: sony prs-t1	Thanx, tha works. :-)

Advert