if you know the input is of the form:

you can use this:

/^"(.*?)", "(.*)", "(.*?)"/g

to give title in $1, messy stuff in $2 and number in $3.
[download]

Note that fairly fixed formatting is assumed. Use \s* as required in place of the space in '", "'.