I'd like to know if there is an easy way of converting the artist name to Rolling Stones, The. Smashing Pumpkins, The. Who, The.
Here is one other option that may interest you.
I leave the
Artist field exactly as auto-populated, but create my own user field called
Artist Sort. This field is calculated and uses the [Swap] expression. This way, any time I import new music, articles are automatically moved to the end (with a comma preceding it) for the custom
Artist Sort field. In addition, it sorts artist names to
last name first. So for artist
Billy Joel, my custom
Artist Sort field is automatically set to
Joel, Billy.
That said, it will also rearrange names that you may not want rearranged. For example:
Big Head Todd & The Monsters will be calculated to:
Monsters, Big Head Todd & The for the
Artist Sort field. This is not terribly problematic however, as long as "Allow Custom Data to Override the Expression" box is checked. It will still automatically switch the name around for
Artist Sort, but you then just copy the unchanged
Artist field and paste that into
Artist Sort, and the override will stick. And better yet… if you decide that you actually prefer the calculated value, simply type "=" in the artist sort field and it will recalculate it back.
As always, backup your library (
File/Library/Back Up Library…) before applying global changes.
Picture for custom library field with with expression to calculate its value:
https://i.imgur.com/d3tni7f.png