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 12-12-2012, 05:52 PM   #1
IGraham
Member
IGraham began at the beginning.
 
Posts: 15
Karma: 10
Join Date: Apr 2012
Device: none
Search and relapse

Bear with me the explanation/request may be non to understandable

In Edit bulk metadata and Search and relapse in the Authors column I have a number of rows as below - and similar for other authors

R. A. Salvatore - [FORGOTTEN REALMS THE LEGEND OF DRIZZT 04]
R. A. Salvatore - [FORGOTTEN REALMS THE LEGEND OF DRIZZT 05]
R. A. Salvatore - [FORGOTTEN REALMS THE LEGEND OF DRIZZT 06]
Etc
Etc

I want to be able to do two things - yes is two separate things but depending upon circumstances
1. Delete all except the authors name - how do I handle the consecutive numbers
2. Keep the Authors name in the Authors column but move the rest to the series column - would be nice to get rid of the brackets

Does anyone know if these can be done

Thanks for any help
IGraham is offline   Reply With Quote
Old 12-12-2012, 08:01 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: 14,223
Karma: 5495470
Join Date: Aug 2009
Location: The (original) Silicon Valley, USA
Device: Galaxy Tab 2, Astak Pocket Pro, K4NT
Quote:
Originally Posted by IGraham View Post
Bear with me the explanation/request may be non to understandable

In Edit bulk metadata and Search and relapse in the Authors column I have a number of rows as below - and similar for other authors

R. A. Salvatore - [FORGOTTEN REALMS THE LEGEND OF DRIZZT 04]
R. A. Salvatore - [FORGOTTEN REALMS THE LEGEND OF DRIZZT 05]
R. A. Salvatore - [FORGOTTEN REALMS THE LEGEND OF DRIZZT 06]
Etc
Etc

I want to be able to do two things - yes is two separate things but depending upon circumstances
1. Delete all except the authors name - how do I handle the consecutive numbers
2. Keep the Authors name in the Authors column but move the rest to the series column - would be nice to get rid of the brackets

Does anyone know if these can be done

Thanks for any help
Why would you bother if you want a relapse?

any quantity of sequential numbers in regex mode: \d+
theducks is online now   Reply With Quote
 
Enthusiast
Old 12-13-2012, 04:43 AM   #3
IGraham
Member
IGraham began at the beginning.
 
Posts: 15
Karma: 10
Join Date: Apr 2012
Device: none
Hello

Really i asked two separate questions, it just seemed a little absurd to have two threads

So
In one circumstance i want to delete
In another i want to separate and move

Knowing how to do both will allow me to cover different circumstances
Get it ?

regex mode: \d+
??
That's probably what I'm looking for as part of an answer, but at the moment i don't know what it is/does or how to apply, and I'd rather not mess up what i have experimenting

So if anyone 'can' help
IGraham is offline   Reply With Quote
Old 12-13-2012, 06:56 AM   #4
IGraham
Member
IGraham began at the beginning.
 
Posts: 15
Karma: 10
Join Date: Apr 2012
Device: none
ok
relapse?
spell checkers are wonderful things - especially if you bother to look at the suggested word
IGraham is offline   Reply With Quote
Old 12-13-2012, 08:18 AM   #5
Adoby
Handy Elephant
Adoby ought to be getting tired of karma fortunes by now.Adoby ought to be getting tired of karma fortunes by now.Adoby ought to be getting tired of karma fortunes by now.Adoby ought to be getting tired of karma fortunes by now.Adoby ought to be getting tired of karma fortunes by now.Adoby ought to be getting tired of karma fortunes by now.Adoby ought to be getting tired of karma fortunes by now.Adoby ought to be getting tired of karma fortunes by now.Adoby ought to be getting tired of karma fortunes by now.Adoby ought to be getting tired of karma fortunes by now.Adoby ought to be getting tired of karma fortunes by now.
 
Adoby's Avatar
 
Posts: 1,024
Karma: 3679628
Join Date: Dec 2009
Location: Southern Sweden, far out in the quiet woods
Device: Ubuntu Linux, Cybook Opus, Motorola Xoom with Mantano Premium
Calibre has great support for search and replace using "Regular Expressions". This is what you use to populate series and series no from the authors field, and to clean up the authors field.

Before you start, make sure that you have a good backup of all books, and that you are comfortable with restoring the backup if needed. There is no undo here. None! You have been warned...

The procedure is done in four steps.

1. Identify and select all books with the same naming structure.
2. Create a RegExp to match the series part of the current authors field. Copy the match into the series field.
3. Create a RegExp to match the series number part of the current authors field. Copy the match into the series no field.
4. Create a RegExp to match the actual authors part of the authors field. Replace the current authors field with the match.

Done!

There are several threads here on this and similar topics. Also about RegExp. Here is one example that may help a little.

http://www.mobileread.com/forums/sho...d.php?t=192415

Last edited by Adoby; 12-13-2012 at 09:39 PM.
Adoby is online now   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
PRS-T1 Search? Schauberger Sony Reader 6 09-21-2012 10:12 PM
Help me search? Please? travger Library Management 1 08-22-2011 07:07 AM
Search? isis Calibre 3 07-08-2011 07:30 PM
Problem using 'Advanced Search' with 'Search in Forum' Wetdogeared Feedback 6 06-21-2011 09:37 AM
Google Book Search to search full-text books online Bob Russell Deals, Freebies, and Resources (No Self-Promotion) 1 08-19-2006 12:13 PM


All times are GMT -4. The time now is 09:41 AM.


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