Remove (CDx) from end of multi disc album title

I have just realised that including (CD1), (CD2) etc at the end of the album title means a multi disc album looks like separate albums in iTunes, Sonos and also Plex which I am now investigating.
I want the players to show a single album with disc1, disc2 split. The Discnumber tags are populated correctly with 1,2 etc.

I need a script to run through all my albums and remove the offending (CD1), (CD2) etc at the end of the album title. Is anyone able to help me out please.

Thanks for tour help

You could try an action of the type "Import tag fields" (Guess value)
Source: %album%
Target: %album% (CD%dummy%

The action is case-sensitive for text constants.