11-05-2017, 02:57 AM | #1 |
Junior Member
Posts: 4
Karma: 10
Join Date: Nov 2017
Device: iPad
|
Extract Series Number from Title
I have a bunch of eBooks in a Series, and the Series Number is together with the title (usually at the beginning). I'm trying to extract the number and copy it to the Series Number field. I am sure there is an easy way to do so with Search and Replace (I have a number of Search/Replace commands stored and used to good effect).
My problem is that I can edit out all non-numbers from the Title, giving me what I want, but sometimes there are numbers elsewhere in the title (like a Year or something else), that is not filtered out and sticks to what si effectively the series number I need. A suggestion of syntax would be most welcome. I sifted though te forum, but I found nothing that gets the job done yet. |
11-05-2017, 03:50 AM | #2 |
The Grand Mouse 高貴的老鼠
Posts: 72,165
Karma: 308792702
Join Date: Jul 2007
Location: Norfolk, England
Device: Kindle Voyage
|
Search: ^(\d+).*
Search Field: title Replace: SeriesName [\1] Replace Field: series The ^ in the search marks the start of the line The () in the search mark a section of the search that's to be used to replace the \1 in the replace field - in this case, \d+, one or more contiguous digits. the .* is just to eliminate the rest of the line. Since we're replacing the complete series field, you need to include the series name in the replace field, so use the actual series name instead of SeriesName. |
Advert | |
|
11-05-2017, 04:07 AM | #3 |
Junior Member
Posts: 4
Karma: 10
Join Date: Nov 2017
Device: iPad
|
It worked like a charm.
Thank you so much. |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Aura Books not listed by title but just "<title> - <number> - <series>" | qee4q | Kobo Reader | 12 | 05-10-2015 04:37 PM |
Want to add the series number to the title of a book | kaufman | Library Management | 3 | 07-14-2013 11:02 PM |
DJVU: Extract number of pages | JensW | Other formats | 1 | 07-06-2013 01:21 PM |
Series Number in Book title (Kindle) | cityzen | Library Management | 7 | 03-20-2011 12:11 AM |
Adding Series and Number to Title. | Cerepol | Calibre | 17 | 09-01-2010 06:50 PM |