You might start over at the beginning.
Author Sorts have Tweaks in Preferences > Tweaks. Update that with what you wish to use.
Author Sorts are found not only for Authors themselves, but for Books, since Books may have multiple authors. Two different things.
First, update each Author's Sort using the Tag Browser context menu to find "Manage Authors", and recalculate all of them.
Afterwards, use Bulk Metadata Edit to update every Book's Author Sort.
Test your results, and iterate as needed.
To include or exclude specific formats, such as PDF, simply double-click appropriately under "Formats" in the expanded Tag Browser.
DaltonST
|