|12-12-2012, 05:52 PM||#1|
Join Date: Apr 2012
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]
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
|12-12-2012, 08:01 PM||#2|
Well trained by Cats
Join Date: Aug 2009
Location: (The original) Silicon Valley, USA
Device: Astak Pocket Pro, K4NT,Galaxy Tab 2
any quantity of sequential numbers in regex mode: \d+
|12-13-2012, 04:43 AM||#3|
Join Date: Apr 2012
Really i asked two separate questions, it just seemed a little absurd to have two threads
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
|12-13-2012, 08:18 AM||#5|
Join Date: Dec 2009
Location: Southern Sweden, far out in the quiet woods
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.
There are several threads here on this and similar topics. Also about RegExp. Here is one example that may help a little.
Last edited by Adoby; 12-13-2012 at 09:39 PM.
|Thread Tools||Search this Thread|
|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|