@theducks no, I'm not trying to do that but the opposite. My entry in the database has the series name series index - book title in the title field and I want to trim that. Therefore I'm trying to scrape series name and index into the series field.
I was trying to do that with the search & replace in bulk metadata mode.
@Manichean where can I perform both operations at once? In search & replace I managed to do it in 2 passes but I was trying to get it working in one. I've setup one to grab the series name and set it and then another to grab the series index and set it. So far I don't know how to input both at the same time since I can only grab one item from the replace list.
Just in case anyone finds the case fitting for their needs:
I want to trim the following name convention:
series_name series_number book title
First I apply the series name to the files:
search title for
replace series name with
in the second pass I grab and set the series index
search title again for
replace series index with