Quote:
Originally Posted by theducks
REGEDIT has to match YOUR title string exactly
Ex: The Title [the series 3] - The Author
(.+)\s+\[.+\d+\]\s-\s(.+)
\1 - \2
|
Thanks theducks. I may be missing something in how to use that regular expression approach:
In the bulk edit search and replace I did the following:
search field: title
search for: (.+)\s+\[.+\d+\]\s-\s(.+)
replace with: \1 - \2
destination field: #test
your test field: Title [3] - Author
but the "test result" field came out as "Title [3] - Author" ... i.e. it did not show any changes.
To expand on my earlier comments, the following illustrates the most common examples that I am coming across for the contents of the title field:
series # - title (i.e. no brackets around the number)
series - # - title
series - title
but I'm not having much luck so far trying to modify that regular expression approach.