Register Guidelines E-Books Search Today's Posts Mark Forums Read

Go Back   MobileRead Forums > E-Book Software > Calibre > Library Management

Notices

Reply
 
Thread Tools Search this Thread
Old 02-26-2013, 08:37 PM   #1
rlh3
Enthusiast
rlh3 began at the beginning.
 
Posts: 44
Karma: 10
Join Date: Jul 2012
Device: iPad 2
Sequential entries in Title field

I have a bit of a problem with cleaning up some title entries in one of my libraries.
I have twenty-plus years worth of several magazines that I need to clean up the title entries on. The Series entries are correct (thanks to the Manage Series plug-in,) but the title entries are not. The standard that I am using in my library is that the series entry is the volume and number for the magazine, and the year and month are included in the title field.
I am wondering if there is a way to make title field changes in quantities greater than a single entry. I want to be able to select a group of books (magazines) and tell Calibre that these are National Geographic 1988-xx, and have Calibre fill in the xx as 01, 02, 03...
If anyone has ideas, please pass them on, I really do not want to have to do this on a title-by-title basis...
rlh3 is offline   Reply With Quote
Old 02-26-2013, 09:10 PM   #2
theducks
Grand Sorcerer
theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.
 
theducks's Avatar
 
Posts: 13,597
Karma: 5126946
Join Date: Aug 2009
Location: The (original) Silicon Valley, USA
Device: Galaxy Tab 2, Astak Pocket Pro, K4NT
Quote:
Originally Posted by rlh3 View Post
I have a bit of a problem with cleaning up some title entries in one of my libraries.
I have twenty-plus years worth of several magazines that I need to clean up the title entries on. The Series entries are correct (thanks to the Manage Series plug-in,) but the title entries are not. The standard that I am using in my library is that the series entry is the volume and number for the magazine, and the year and month are included in the title field.
I am wondering if there is a way to make title field changes in quantities greater than a single entry. I want to be able to select a group of books (magazines) and tell Calibre that these are National Geographic 1988-xx, and have Calibre fill in the xx as 01, 02, 03...
If anyone has ideas, please pass them on, I really do not want to have to do this on a title-by-title basis...
Does the Series_index contain the numbers you want to use?
One of the (bulk mode S&R) replace values is Calibre fields {series_index} for example
theducks is offline   Reply With Quote
Old 02-26-2013, 09:16 PM   #3
rlh3
Enthusiast
rlh3 began at the beginning.
 
Posts: 44
Karma: 10
Join Date: Jul 2012
Device: iPad 2
Unfortunately, no.

just pulling some values out of my hat, it looks like this:

Series:
National Geographic [188.01]
National Geographic [188.02]
National Geographic [188.03]
(This is the Volume and Number information for the magazine)

and what i want to put in the title is:
National Geographic 2008-01
National Geographic 2008-02
National Geographic 2008-03
(I want this to be the year and month of publication)
rlh3 is offline   Reply With Quote
Old 02-26-2013, 09:32 PM   #4
theducks
Grand Sorcerer
theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.
 
theducks's Avatar
 
Posts: 13,597
Karma: 5126946
Join Date: Aug 2009
Location: The (original) Silicon Valley, USA
Device: Galaxy Tab 2, Astak Pocket Pro, K4NT
Quote:
Originally Posted by rlh3 View Post
Unfortunately, no.

just pulling some values out of my hat, it looks like this:

Series:
National Geographic [188.01]
National Geographic [188.02]
National Geographic [188.03]
(This is the Volume and Number information for the magazine)

and what i want to put in the title is:
National Geographic 2008-01
National Geographic 2008-02
National Geographic 2008-03
(I want this to be the year and month of publication)
It might get a little tricky pulling the fractional part of the series Index,
but you should be able to construct
Play with this idea REGEX mode

DESTINATION: Title APPEND value: 2008-\1

Search series_index: \d+\.(\d+)
theducks is offline   Reply With Quote
Old 02-26-2013, 10:18 PM   #5
rlh3
Enthusiast
rlh3 began at the beginning.
 
Posts: 44
Karma: 10
Join Date: Jul 2012
Device: iPad 2
I will play with this a bit, but my RegEx-fu is weak.
We may be making this a bit more complex than necessary. I am using the series_index to put the magazines in order, but if the replace in the title field were simply sequential, (xxxx-01, xxxx-02 etc.) it would be more than satisfactory. (e.g. I pick the magazines for the year 2008, make sure that they are in order, and then apply a replace to the title field such as: National Geographic 2008-xx, with the xx being a series of numbers 01, 02, 03...)
rlh3 is offline   Reply With Quote
Old 03-10-2013, 11:12 PM   #6
rlh3
Enthusiast
rlh3 began at the beginning.
 
Posts: 44
Karma: 10
Join Date: Jul 2012
Device: iPad 2
I played around with this a bit, and, as I feared, my RegEx-fu was not strong enough to get it to work.
Is there any way of pasting a sequence like I described in the post just above, and ignoring the series_index completely?
Also, does it change things if the series_index is a whole number?
rlh3 is offline   Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
remove author from title field er0_senn1n Calibre 2 09-30-2012 04:50 PM
Copy data from Title field to IDs field rlh3 Library Management 9 09-24-2012 08:12 AM
Search/Replace from Title Field to Pubdate TMSxMR Library Management 5 08-06-2012 03:40 AM
Reg ex to move 'by author' from title field maartencoertjens Library Management 3 10-20-2011 04:26 PM
Changing the title field when sending to the Kindle Cheezykins Devices 3 06-19-2011 09:14 AM


All times are GMT -4. The time now is 02:35 AM.


MobileRead.com is a privately owned, operated and funded community.