All these can be solved using the edit metadata/in bulk/search and replace, and some careful work with regular expressions.
For example, "Lname, Fname" in the author field can be reversed with
search field: authors
search for: (.*), (.*)
replace with: \2 \1
Watch out for those occasional authors whose names genuinely contain commas, e.g. "Alexandre Dumas, pere".
A similar (but more complex) recipe can move the correct chunks out of the title into the series field, and then a second pass to fixup the title.
|