Forgive my criticism, but this isn't something I would have expected to have to manually clean up as I'm not a database expert and don't want to be.
As you now know, you don't need
my forgiveness. Besides, I think the criticism is well deserved. But not for the reasons you seem to believe.
Very few of us (and certainly not me) are 'database experts'. Nor does the essential design of the program assume any user is. But it is a database. And the program is already more powerful and robust than any other of its type. Most of these things are very straightforward, as long as things are presented to the user in way that makes clear what's going on. You didn't say (and I'm impressed you were able to spot trailing spaces as the culprit), but I suspect you could readily see the problem once you followed my suggestion. That understanding, along with ability to use some of the basic capabilities of the program, will put you in the position of being able to isolate and resolve such issues
for any number of files with only a few commands.
I've suggested to JRiver this particular issue and some like it could be alleviated by providing some stock smartlist views the bring such issues to the user's attention and illustrate how they might be fixed. If there were a branch in the view tree
Audio > Diagnostics > Split Albums, it seems likely to me you would notice it. If it displayed only 'split album' files and the columns I suggested you display, the pattern alone would suggest to most users what was wrong. Those needing help would be able to explain exactly what they were seeing (or post a screenshot) so more experienced users could help. I have no idea why, but it seems the suggestion has fallen on deaf ears.
Although you will be forever challenged by this, I encourage you not to decide the program is in any way designed for a level of expertise beyond what you're capable of. In time, you'll discover that which seems inaccessible is actually a straightforward capability that allows you to easily do what is very difficult or impossible to do in other programs. I won't claim it's easier to use than iTunes. But I find the most difficult software is that which is simply incapable of doing what I need it to do. The most difficult thing to do in MC is determine with any certainty what it
cannot do.