Renameing issue for idiot

Hi
in the past i have been renaming my albums title and CD number by manual, i have had a play about with the actions but with no luck, i have over 1000 albums to rename and wondered if all possible somebody could point me in the direction to get the actions working

EXAMPLE
my current layout has the Album tag as
NOW THATS WHAT I CALL MUSIC 21- CD1
NOW THATS WHAT I CALL MUSIC 21- CD2
NOW THATS WHAT I CALL MUSIC 21- CD3
NOW THATS WHAT I CALL MUSIC 21- CD4
NOW THATS WHAT I CALL MUSIC 21- CD5
but the disc number tag empty
i would like to rename the Album tag to remove the CD1 and add a 1 to the disc tag
so the albums would read
NOW THATS WHAT I CALL MUSIC 21
and the disc tag would read 1 or what ever the cd is

i am sure this is very easy if you know what to do and could save me hours

thanks

You can try an action of the type "Guess value" for ALBUM:
Guessing pattern: %dummy% CD%discnumber%
This should put the values behind "CD" into the field DISCNUMBER.

The second action would also be of the type "Guess value", for ALBUM again:
Guessing: %album% - CD%dummy%
this should cut everything following the hyphen.

Hi there,

you can use an action Guess values where you use %album% as "Source format" (this is where the data comes from) and %album%- CD%discnumber% as "Guessing pattern" (this is how the data should be distributed among fields).

Kind regards
– Florian

Thank you for your help, i am now able to sort this using the above method