Converting title, tag, or filename to album without including all text included in filename

All the tracks I work with in MP3Tag are for classical music. I began to name my files years ago, and developed a structure for them that, at least at my level of understanding, now makes it impossible for me to use the "convert" actions in MP3Tag to fill in the metadata fields without substantial manual editing. I'd like to find a way to do that with less user intervention.

Here's a typical file name. "Franz Joseph Haydn - Antal Dorati, Philharmonia Hungarica - Symphony No. 101 in D Major ('The Clock'), Hob. I101 - II. Andante" That presents metadata types in this order: %Artist% - %AlbumArtist% - %Title%. As you can see, using that format for the variables leaves me with the album tag blank.

What I'd like to get done for each track is to end up with these bits of data in the relevant fields:

 ARTIST: Franz Joseph Haydn
 ALBUM ARTIST: Antal Dorati, Philharmonia Hungarica
 ALBUM: Symphony No. 101 in D Major ('The Clock'), Hob. I101
 TITLE: Symphony No. 101 in D Major ('The Clock'), Hob. I101 - II. Andante" 

I thought I could develop my desired entry in the %Album% field with a multi-pass approach, but I can't figure out how to do the second step. First, I can use the "Convert filename > tag" approach shown above to fill most of the relevant fields.

However, although I can then fill the album field by using the "Convert tag > tag" approach, and setting %Album% = %Title," that leaves me with undesired data in the album field. I don't want the info about the movement # and tempo markings (II. Andante) to show there. To get a "clean" album field, I need to manually delete the movement # and tempo markings from the album field for each track. That's way too much work for 6,000+ files.

I know the problem is caused by the fact that I have movement # and tempo markings placed after a 4th hyphen, but I can't figure out a way to work around that.

Any ideas?

Please show us exactly what the final data in the different fields should look like for
ARTIST
ALBUMARTIST
ALBUM
TITLE
for the above filename
Franz Joseph Haydn - Antal Dorati, Philharmonia Hungarica - Symphony No. 101 in D Major ('The Clock'), Hob. I101 - II. Andante

Do you really want to duplicate
Symphony No. 101 in D Major ('The Clock'), Hob. I101
in ALBUM and TITLE?

If you only want to see
II. Andante
in TITLE, we could use a regular expression for that part.

I don't think I can add to what I said originally: "What I'd like to get done for each track is to end up with these bits of data in the relevant fields:

ARTIST: Franz Joseph Haydn
ALBUM ARTIST: Antal Dorati, Philharmonia Hungarica
ALBUM: Symphony No. 101 in D Major ('The Clock'), Hob. I101
TITLE: Symphony No. 101 in D Major ('The Clock'), Hob. I101 - II. Andante"

Because of what shows up, and doesn't show up, when playing tracks outside of MP3Tag, like in CarPlay or other MP3 players, I want the data in the title field to duplicate MOST of the data in the album field.

Step #1:

Convert Filename -> Tag:
Format string:
%ARTIST% - %ALBUMARTIST% - %TITLE%

Step #2:
Convert Tag -> Tag:
Field: ALBUM
Format string:
$regexp(%TITLE%,(.*) - .*,$1)

Final result:

Terrific! You nailed it! Thanks a lot.