Removing 'The' from Album Artist

[phred]

How do I make "The" -not- appear when ripping a CD?  I have file naming set to
<Sort Album Artist>\<Album>\<Disc-Track#> - <Title>

When ripping a CD by The Beatles, I want the Album Artist or Sort Album Artist to be simply "Beatles" as I don't like the way "Beatles, The" looks.  The Album Artist, or Sort Album Artist tags for the individual files are okay as "The Beatles" because MB ignores the "The" when sorting/searching.

Thanks.

[Zak]

Can't you just change the Album Artist to "Beatles" before you rip?

Or are you saying you want the Album Artist tags to be "The Beatles" and you just want the folder to be "Beatles"?
If the latter I can't see how to do that with the functions currently available in MusicBee.

You can't just use $Replace(<Album Artist>,The,) because that will replace all instances of "The" not just those at the start, and in the absence of a string length function there's no way to get just the part after "The". 

[Bee-liever]

You can't just use $Replace(<Album Artist>,The,)

No, but you can use
$RSplit($Sort(<Album Artist>),",",2)

[phred]

Can't you just change the Album Artist to "Beatles" before you rip?

If I did that, then the individual tracks would be tagged as "Beatles" for the Artist instead of "The Beatles."

Or are you saying you want the Album Artist tags to be "The Beatles" and you just want the folder to be "Beatles"?

Yes, exactly.

You can't just use $Replace(<Album Artist>,The,)

No, but you can use
$RSplit($Sort(<Album Artist>),",",2)

Thanks.  I will give this a try later today.

EDIT:  Works perfectly!!  Thanks!

[psychoadept]

Although you might have to modify this for aritsts with commas in their name, like "Blood, Sweat, and Tears".

As long as you're confident that you don't have artists that both begin with The AND have a comma in them, you can use this:

$If($Left(<Album Artist>,3)="The",$RSplit($Sort(<Album Artist>),",",2),<Album Artist>)

If you're not sure of that, or have other special cases to deal with, you might need to take advantage of the Sort Album Artist field. 


This is the virtual tag I use for grouping in the library and folder names on the computer (I split from the left rather than the right, but otherwise it uses the same formula to get rid of "The"):

$If($Or(<Album Artist>="[Compilation]",<Genre>="TV Clip"),$Split(<Sort Artist>,",",1),$If(<Album Artist>=<Sort Album Artist>,<Album Artist>,$Split(<Sort Album Artist>,",",1)))