There are periods in the title. FUN
(dot is a wildcard in REGEX and must be escaped)
First OFF. this BULK MODE EDIT Search and Replace
My REGEX pattern only works for your books that are Exactly the same as shown
VERIFY in the TEST results before committing (and Keep a backup)
Learn REGEX Basics, it will serve you well
There are a couple of good REGEX tutorials (Pablo and Manichean)
Step 1: Copy (prior to Remove) the Author
Search field Title:
Search for (.+)\.(.+)\.-\.(.+)
Replace with \2 \1 << flips the order with a space
Apply Function (on right) Titlecase
Destination field Author
You need a different pattern
set for Author with Initials, Generations or Titles
Once the Author FIELD is done, we need to clean the title
Same Search field and term
Destination field is Title
Replace With \3 <everything past the
.-.
Why not take care of the Case at this using the SAME as above?
From here on, The Title cleanup requires unique solutions