There is no easy solution, and no one easy regexp that can fix all your books. You will most likely need to group your books, based on naming standard used, and handle each group separately. And books that you can't group like this will most likely have to be fixed manually. One easy way to group is to hold down Ctrl and select each book. Or shift to select sequences of books. Another way is to do a search. Perhaps using a regexp. Or just sort on publisher or some other field to find groups of books that use the same naming standard.
I am afraid that you will have to be a little more specific with the details to get a more useful answer. Otherwise you may not get more than just suggestions to read a book about regexps and/or to read the relevant sections of the manuals for calibre and python.
Also you may get more and better help if you start a separate threads for your problems, and use good titles for the threads.
To get a really good answer, you usually have to ask a really good question...