Originally Posted by anvarit
That worked great, if you have the time could you explain the expression ".* -"?
. : any character
* : repeat as many times as possible unitil the next literal in the regex
- : literal space and dash
This matches anything up to and including the dash in your author field (and because of the empty 'Replace with' removes it), leaving the number as the result to move into the series_index field.
More on Python regular expressions: http://docs.python.org/library/re.html