03-11-2015, 02:35 PM
|
#1 |
|
Junior Member
 Posts: 2
Karma: 10
Join Date: Mar 2015
Device: None
|
Need help with a regex expression
I have a large number of titles in the format below and am looking to transfer the information to the correct fields:
555 Book title (author name) Where 555 is the series number I am trying to put a regex together to move the number to the series_index field as well as move the author to the author field but am falling dreadfully short in my knowledge. Any help is greatly appreciated. |
|
|
|
03-11-2015, 03:24 PM
|
#2 | |
|
Well trained by Cats
 
Posts: 31,054
Karma: 60358908
Join Date: Aug 2009
Location: The Central Coast of California
Device: Kobo Libra2,Kobo Aura2v1, K4NT(Fixed: New Bat.), Galaxy Tab A
|
Quote:
You have a bigger problem  You can't import a series index without a series Name (also) preexisting You need to use a file renamer to insert the series name before import as Calibre can not use path info. You could use the Manage Series PI to help do in bulk, (this is a per-series task) THEN use Bulk metadata edit to finish the cleanup of the Title (remove the number) |
|
|
|
|
| Advert | |
|
|
|
03-11-2015, 03:33 PM
|
#3 |
|
Junior Member
Posts: 2
Karma: 10
Join Date: Mar 2015
Device: None
|
Sorry, I should have been a bit clearer. These are already imported and the series name is set. The title field in calibre has the data listed in the first post
|
|
|
|
|
03-11-2015, 04:00 PM
|
#4 | |
|
Well trained by Cats
Posts: 31,054
Karma: 60358908
Join Date: Aug 2009
Location: The Central Coast of California
Device: Kobo Libra2,Kobo Aura2v1, K4NT(Fixed: New Bat.), Galaxy Tab A
|
Quote:
555 Book title (author name) search title: (\d+)\s.+ destination: series_index Replace With: \1 search title: \d+\s.+\s\((.+?)\) Then cleanupdestination: authors Replace With: \1 search title \d+\s(.+?)\s\(.+?\) replace \1 you are replacing the title Always check the test results AND ALWAYS pull a full Backup BEFORE |
|
|
|
|
 |
«
Previous Thread
|
Next Thread
»
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Help with regex expression for words in all caps | bfollowell | Sigil | 9 | 01-20-2012 05:11 PM |
| Expression? | TwinmtnNH | Library Management | 8 | 03-25-2011 01:55 PM |
| Help with a Regex Expression? | adept22 | Library Management | 2 | 03-16-2011 06:50 AM |
| help with regex expression | daesdaemar | Workshop | 4 | 02-19-2010 07:38 AM |
| Need help with regex expression | daesdaemar | Workshop | 18 | 02-07-2009 03:48 PM |
All times are GMT -4. The time now is 01:55 AM.