generate series from title using search and replace

richreads · 06-12-2012, 09:02 PM

Hi.
I have a number of comics that I have just imported into calibre.
I have them listed by title as 'name v1 #xxx' and would like to use that as the series using the Search and Replace tab in the edit metadata bulk screen.
For example title = 'Superman v1 #139'
I would like the series to be 'Superman v1 [139]'.
For the search field I selected title and 'superman v1 #[0-9][0-9][0-9]' and then series as the destination.
I tried a couple of variations on 'superman v1 [0-9][0-9][0-9]]' as the replace with mask but nothing seemed to work.

Is thsi possible? I so what do I need to change?

richreads · 06-12-2012, 10:27 PM

Hi - Don't worry about it.
I figured it out.

Gunnerp245 · 06-13-2012, 07:58 AM

What was the resulting solution? It might help someone else in the future.

richreads · 06-13-2012, 10:47 AM

As Gunner suggested here is my solution.
Rather than try and describe my solution I just took a screen shot.

Gunnerp245 · 06-14-2012, 06:54 AM

Quote:

Originally Posted by richreads

...

BookJunkieLI · 06-14-2012, 09:36 AM

Awesome. I've been doing the same thing by hand. This will make things much faster.

:

06-13-2012, 10:47 AM	#4
richreads Connoisseur Posts: 53 Karma: 10 Join Date: Mar 2009 Location: Hamilton, ON Device: Kobo Touch and Glo,	As Gunner suggested here is my solution. Rather than try and describe my solution I just took a screen shot. Attached Thumbnails

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Plugboard "Metadata: Show series [series index] - title as title (Kindle)"	Deep Cover	Library Management	6	11-30-2012 05:17 PM
Search And Replace using Series value?	Robmonster	Calibre	7	11-15-2011 10:59 AM
Cleaning Title Names using Search and Replace	JTAL604622	Calibre	2	05-24-2011 05:23 AM
search and replace - drops blanks in replace ?	cybmole	Conversion	10	03-13-2011 03:07 AM
Setting series index in bulk metadata search&replace	bubak	Calibre	4	12-19-2010 04:04 PM

06-12-2012, 09:02 PM	#1
richreads Connoisseur Posts: 53 Karma: 10 Join Date: Mar 2009 Location: Hamilton, ON Device: Kobo Touch and Glo,	generate series from title using search and replace Hi. I have a number of comics that I have just imported into calibre. I have them listed by title as 'name v1 #xxx' and would like to use that as the series using the Search and Replace tab in the edit metadata bulk screen. For example title = 'Superman v1 #139' I would like the series to be 'Superman v1 [139]'. For the search field I selected title and 'superman v1 #[0-9][0-9][0-9]' and then series as the destination. I tried a couple of variations on 'superman v1 [0-9][0-9][0-9]]' as the replace with mask but nothing seemed to work. Is thsi possible? I so what do I need to change?

06-12-2012, 10:27 PM	#2
richreads Connoisseur Posts: 53 Karma: 10 Join Date: Mar 2009 Location: Hamilton, ON Device: Kobo Touch and Glo,	Hi - Don't worry about it. I figured it out.

06-13-2012, 07:58 AM	#3
Gunnerp245 Gadget Freak Posts: 1,169 Karma: 1043832 Join Date: Nov 2007 Location: US Device: EE, Note 8	What was the resulting solution? It might help someone else in the future.

06-14-2012, 09:36 AM	#6
BookJunkieLI Evangelist Posts: 435 Karma: 572984 Join Date: Jan 2010 Location: Long Island Device: Kobo Libra 2, Kindle 4, Nook Gl4, Nook STR, REB 1100, Ebookwise 1500,	Awesome. I've been doing the same thing by hand. This will make things much faster. :

Advert

Advert