Bulk Metadata Title Help

braxas · 10-01-2013, 09:16 AM

Hi all!

I need some help with Calibre ebook management. I have a bunch of books where the title looks like:

series name [series #] title name

I'd like to remove the series name with the number's in brackets and just leave the title name in place. Is there an expression setup I can use for the bulk metadata edit while using search and replace? I was looking at the different expressions and can not make sense of it. Thanks for the help, I appreciate it!

Adoby · 10-01-2013, 12:54 PM

Try searching for:

^(.+)\s\[(.+)\]\s(.+)$

and replace with \3

\1 is series name, \2 is series #, \3 is title name.

But as always when using search and replace, make sure you have a recent backup. There is no undo...

braxas · 10-01-2013, 01:24 PM

That works perfect! Thanks so much for the help, that'll be a great time saver! And I definitely have a backup, always a must when doing computer stuff.

tosim · 10-06-2013, 07:44 PM

Quote:

Originally Posted by Adoby

Try searching for:

^(.+)\s\[(.+)\]\s(.+)$

and replace with \3

\1 is series name, \2 is series #, \3 is title name.

But as always when using search and replace, make sure you have a recent backup. There is no undo...

Could someone please be a little more specific re the above expression. Does it mean that the first (.+) gets filled in like (.+series name), etc.?? Thank you for any help on this.

Adoby · 10-07-2013, 03:57 AM

The parentheses creates groups. I put in the parentheses so that the main elements in the searched string would get a separate group. I then simply put the separators, what is between the main elements, between the parentheses to make the right things match. Done!

So the first parentheses will match series name, the second will match the series number and the third parentheses will match the actual title. To use the matches later it is possible to refer to them by number. So when replacing the original title with the actual title I replace it with \3.

To solve the problem as specified only the third parentheses was actually needed. I had all three to help me keep track of where I was in the match, and perhaps also to make the expression more generally usable. It could be used to fill in series information before it is used to set the correct title.

I could have used

^.+\s\[.+\]\s(.+)$

Instead, and replaced with \1 to fix the title.

10-01-2013, 09:16 AM	#1
braxas Junior Member Posts: 2 Karma: 10 Join Date: Aug 2010 Device: Nook HD+	Bulk Metadata Title Help Hi all! I need some help with Calibre ebook management. I have a bunch of books where the title looks like: series name [series #] title name I'd like to remove the series name with the number's in brackets and just leave the title name in place. Is there an expression setup I can use for the bulk metadata edit while using search and replace? I was looking at the different expressions and can not make sense of it. Thanks for the help, I appreciate it!

10-01-2013, 12:54 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	Try searching for: ^(.+)\s\[(.+)\]\s(.+)$ and replace with \3 \1 is series name, \2 is series #, \3 is title name. But as always when using search and replace, make sure you have a recent backup. There is no undo... Last edited by Adoby; 10-01-2013 at 01:01 PM.

10-07-2013, 03:57 AM	#5
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	The parentheses creates groups. I put in the parentheses so that the main elements in the searched string would get a separate group. I then simply put the separators, what is between the main elements, between the parentheses to make the right things match. Done! So the first parentheses will match series name, the second will match the series number and the third parentheses will match the actual title. To use the matches later it is possible to refer to them by number. So when replacing the original title with the actual title I replace it with \3. To solve the problem as specified only the third parentheses was actually needed. I had all three to help me keep track of where I was in the match, and perhaps also to make the expression more generally usable. It could be used to fill in series information before it is used to set the correct title. I could have used ^.+\s\[.+\]\s(.+)$ Instead, and replaced with \1 to fix the title. Last edited by Adoby; 10-07-2013 at 04:06 AM. Reason: Grammar fixed some was

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Title bulk edit match - to remove series info from title	Rob557	Library Management	30	12-09-2014 06:06 AM
Title not changed with Bulk Editing	stormsh	Calibre	6	09-23-2013 09:18 PM
Bulk move 'The' and 'A' to end of Title	macnab69	Library Management	3	01-28-2013 09:26 AM
Bulk title replacements	mumdigau	Recipes	0	07-22-2012 12:34 PM
Bulk Title Mod Option??	kksdragons	Library Management	1	10-27-2011 10:42 PM

10-01-2013, 01:24 PM	#3
braxas Junior Member Posts: 2 Karma: 10 Join Date: Aug 2010 Device: Nook HD+	That works perfect! Thanks so much for the help, that'll be a great time saver! And I definitely have a backup, always a must when doing computer stuff.

Advert

Advert