i am sooooo close i can feel it

now about your question of how it fills in the metadata card you are right it's like this:
Carnivores of Light and Darkness {Title} Foster, Alan Dean {Author(s)}
so my most important issue now is retaining the series names and numbers.
i want:
Foster, Alan Dean - Catechist 02 - Carnivores of Light and Darkness
to look like this:
Catechist 02 - Carnivores of Light and Darkness {Title} Foster, Alan Dean {Author(s)}
i totally understand what you mean about authors with multiple names and how it can confuse. i still need to find a way to convert most of my {Author(s)} so that they are in the {Author(s)} fields in the Author Sort format, but the search and replace info doesn't seem to be working. i don't know if i am doing it wrong or not understanding or what. but it doesn't change anything.
I don't want to start inputing them now as Foster, Alan Dean {Author(s)}, when i have 4000 books as Alan Dean Foster {Author(s)}