Regex help needed to fix titles

CWatkinsNash · 02-07-2012, 08:01 PM

I have some series books that have the series info in the title. (Yes, I did this, way back before I started using plugboards, and I'm just now getting around to fixing some of them.) I have a rudimentary knowledge of regex (in fact, I think that's how I got them this way to begin with), but I can't get my head around this one.

Ex: Series Name 4 - Title

I need to remove everything before the title. Help?

theducks · 02-07-2012, 08:31 PM

Quote:

Originally Posted by CWatkinsNash

I have some series books that have the series info in the title. (Yes, I did this, way back before I started using plugboards, and I'm just now getting around to fixing some of them.) I have a rudimentary knowledge of regex (in fact, I think that's how I got them this way to begin with), but I can't get my head around this one.

Ex: Series Name 4 - Title

I need to remove everything before the title. Help?

First of all, use Search and Replace tab on the Bulk Metadata editor

Select books with an Identical problem:

The Search field: Title
The mode is Regex
the pattern: (.+ \d+ - ) Note the spaces surrounding the dash and just before the \d

The samples should Exactly agree with what you want. (adjust or remove) undesired changes. pay attention to non-discernible leading spaces.

move the cursor. if it stay at the front of the first letter, you still have a space
Apply

space\d+space matches the numbers (any quantity together)

CWatkinsNash · 02-07-2012, 08:38 PM

Works perfectly, and your explanation allowed me to adapt it for a few that were a little different. Yay!

02-07-2012, 08:01 PM	#1
CWatkinsNash IOC Chief Archivist Posts: 3,950 Karma: 53868218 Join Date: Dec 2010 Location: Fruitland Park, FL, USA Device: Meebook M7, Paperwhite 2021, Fire HD 8+, Fire HD 10+, Lenovo Tab P12	Regex help needed to fix titles I have some series books that have the series info in the title. (Yes, I did this, way back before I started using plugboards, and I'm just now getting around to fixing some of them.) I have a rudimentary knowledge of regex (in fact, I think that's how I got them this way to begin with), but I can't get my head around this one. Ex: Series Name 4 - Title I need to remove everything before the title. Help?

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Help with regex needed.	kamanza	Library Management	3	01-24-2012 07:27 AM
RegEx Help needed	ghostyjack	Sigil	14	11-02-2011 10:22 AM
Regex - Library Order Fix?	penguinaka	Library Management	3	07-29-2011 03:59 AM
regex to fix up hyphenated words please	cybmole	Sigil	2	01-06-2011 04:13 AM
Regex help needed	gandor62	Calibre	2	11-04-2009 10:27 AM

02-07-2012, 08:38 PM	#3
CWatkinsNash IOC Chief Archivist Posts: 3,950 Karma: 53868218 Join Date: Dec 2010 Location: Fruitland Park, FL, USA Device: Meebook M7, Paperwhite 2021, Fire HD 8+, Fire HD 10+, Lenovo Tab P12	Works perfectly, and your explanation allowed me to adapt it for a few that were a little different. Yay!

Advert