Thread: Regex help needed to fix titles
View Single Post
Old 02-07-2012, 08:31 PM   #2
theducks
Well trained by Cats
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: 31,098
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:
Originally Posted by CWatkinsNash View Post
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)
theducks is offline   Reply With Quote