Quote:
Originally Posted by racergirl76
I've been combing these forums for a week looking for a solution and am now admitting defeat.
I stongly prefer the Title field contain the full (long) title of a book:
"Maintitle of Book: Subtitle aka Strapline"
For more effencient use of the title contents for writing to disc/saving, templates, and for plugboards, I need to parse the title into two userdefined columns
"#maintitle" & "#subtitle"
So, I tried using the custom column feature, BUT the colon ":" is part of the regex language and my non-existant regex skills can't figure out how to tell it to
1. Take everything before the ':' and copy to #maintitle
2. Take everything after the ': ' and copy to #subtitle
Workarounds such as manually separating the subtitle into comments or another column promotes inconsistency and incompleteness that doesn't work for me.
Any help is greatly appreciated, assume I know nothing about Regex. Reading the tutorials and absorbing them are two different things.
|
Use the Search and replace tool of the bulk metadata edit against only those books with the : REGEX MODE
search field: title
search for (.+?)\:(.+?)
Destination will be done in 2 passes
destination Pass1: #maintitle
replace with: \1
destination Pass2: #subtitle
replace with: \2