[Adoby]

You can use bulk edit metadata and regular expressions to search and replace.

Search the title for

^(.*) - (.*) - (.*)$

And replace with \2. That will give you just the name of the book without series name or series index.

Before you do that you can also replace the series field with \1 and series index with \3.

Each set of parentheses creates a group that match a specific part of the title. Between the groups are the separators. In this case " - ". And you can refer to each group by the order of appearance.

\1 is the series name, "Doctor Who".
\2 is the actual title, "Target Novelisations".
\3 is the series index, "019".

^ and $ are used to specify start of the line and end of the line of text.

Regular expressions are very good to know. And extremely useful for most computer users, not only calibre users.