Not the answer to the import part.
But the fix for existing is easy
Quality check Plugin
Step 1 is to identify.
Check Metadata: Authors with commas
Select all
Step 2
Fix: Swap Author Fn...
Do check out all the things this PI can do
Why from filenames? Embedded metadata is usually more complete . Tick
read from contents in
Preferences: adding books