I wish to regenerate the metadata in a set of epub books that use the following filename format.
author_lastname, author_firstname - title.epub
for example,
Scott, Sir Walter - Anne of Geierstein.epub
The desired metadata is,
title = Anne of Geierstein
author = Scott, Sir Walter
author sort = Scott, Sir Walter
I can get the desired title and author metadata by unchecking the "read metadata from files" box, and then adding the book with the regular expression,
(?P<author>,+) - (?P<title>[^_]+)
But the author sort metadata is created as,
Walter, Scott, Sir
I have spent some time looking for a solution in the Calibre User Manual but haven't found one. Can anyone help with this? Thanks.