
Fix them (in Calibre) in groups
by pattern
You will need to know some REGEX
Select members of a pattern group to fix: Tap 'e' (metadata edit bulk mode): Switch to th Search and Replace Tab: Select Title as the Search field
The rest is REGEX captures (for) and Replace (or copy to a new column) and / or post process.
Practice on a Copy library . This is one powerful tool that can do a lot of harm if you are not prefect

have a FULL LIBRARY BACKUP is a good plan