|
There's not enough information to answer your question.
I don't mean your question wasn't clear and precise. I mean that in order to clean up the series, you have to add information to the system, namely the corrected series names.
This information has to come from somewhere, because at the moment, it's not in your library. Maybe there's a better source to download your metadata, and you just have to tweak your settings. Or you can make certain assumptions and write some regular expressions to fix common errors (like the one TheDucks suggested). Or you go through the books one at a time and use your own judgment to determine the correct series.
Unfortunately, nothing can substitute for checking them all by hand. You're going to have to accept that at some point, you'll need to do that. Some good regular expressions can do a lot of the work for you, but after running them you'll need to go through the books and make sure the series are correct.
Once you get to that point, I recommend sorting or filtering by author. This should at least group all the books that should be in the same series near each other. Then you can make any corrections and move on to the next author. This will also allow you to work on this in batches, because you just have to remember the last author you cleaned up and start from there the next time.
You might also create a custom Yes/No column for whether you've corrected the metadata on that book. Feel free to delete the column after you've finished cleaning your library.
Once you do have your series cleaned up, get into the habit of checking your metadata by hand every time you add new books or downloading metadata. I've always treated downloaded metadata as a suggestion, not an an authority on the correct values. Someone, somewhere, decided that was what they wanted to put in the fields in their library, but it might not be what you want in yours. Checking the data for a few books at a time will prevent you having to go through your entire library later.
|