Help dealing with albumartistsort

[sjkiss]

I basically need one script that does the following:

1. Sets the albumartistsort extended tag field to be equivalent to the "Album Artist" field unless
2. there is a "The" in which case, I would like the albumartistsort field to read "Album Artist, The".

Is this possible?

[ohrenkino]

To make it easier: I am pretty sure that the "The" is not necessary any more to sort better.

So I would suggest that you use an action of the type "Format value" or Convert>Tag-Tag for ALBUMARTISTSORT
Format string: $regexp(%albumartist%,^The ,)
This simply
Please watch out for artists that seem to need the "The" like "The The" or "The Band", "The XX".

[sjkiss]

I don't understand what this does:
$regexp(%albumartist%,^The ,)

[ohrenkino]

Have you tried it?
It removes any leading "The " and leaves the rest.
And as I said: if you add the trailing "The" will not make any difference for sorting.

See also here:

Create A New Action to swap first name last name to last name, first name

I have downloaded MP3TAG to a new computer and require some assistance. Stupidly I did not take a backup of my original which had purpose made 'ACTIONS' I have lost my copy of the syntax code to create 2 separate 'Actions' To enable ARTISTSORT to convert for example, (Artist) Elvis Presley to Artistsort) Presley, Elvis. To enable ARTISTSORT to convert for example (Artist) The Beatles to (Artistsort) Beatles, removing the 'The' from group names. I would appreciate some help. A Basic …

[sjkiss]

The other problem that I have is a lot of albumartistsort fields are something like "Drake, Nick" and I would like it to be "Nick Drake.
I can see how your script would solve my problem for the "The" though. But how do I solve the first problem? All my Album Artist fields are the way I want them, I just wanted to port over what is in Album Artist to albumartistsort.

[MotleyG]

@sjkiss

All my Album Artist fields are the way I want them, I just wanted to port over what is in Album Artist to albumartistsort.

This is a simple Convert Tag-Tag and set Albumartistsort to be Albumartist.

But why would you want these to be identical? It defeats the purpose of having the sort field. It is intended to allow you to have the Albumartist displayed as expected but sorted under a different way. Removing articles like A, An, and The are the most obvious ones in English. Your other example of Drake, Nick is to have that artist sorted under the D's as you would find them in store.

Otherwise you can leave this field u filled and most players and media managers will default back to the standard field.

[ohrenkino]

@sjkiss

I can see how your script would solve my problem for the "The" though. But how do I solve the first problem?

My suggestion would copy ALBUMARTIST to ALBUMARTISTSORT in all cases and only for those with a leading "The" it would leave out that article.

And in general for the problem of copying fields, there is a post in the FAQs:

Actions and batch-operations

How to copy one field value to another field? Example how to copy the content of the ARTIST field to the ALBUMARTIST field: Create a new action in an existing action group or make a new action group. Action type: Format value Field: ALBUMARTIST Format string: %artist% Note: If you want to copy all possible values of a field (in case you have multiple artist fields), the internal scripting function $meta_sep can be used in the format string, e.g., $meta_sep(artist,\\\\)

[sjkiss]

My suggestion would copy ALBUMARTIST to ALBUMARTISTSORT in all cases and only for those with a leading "The" it would leave out that article

How do I do that if-then construction?

[ohrenkino]

@sjkiss

that if-then construction

For what would you need such an if-then construction?
The regular expression works without that.
The condition is "built-in", so to say, as the regular expression returns the original string if the pattern has not been found.

See the documentation on regular expressions:

Regular Expressions – Mp3tag Documentation

[ohrenkino]

@sjkiss

fields are something like "Drake, Nick" and I would like it to be "Nick Drake.

It would be extremely tricky to separate the artists that have swapped names from those that actually have a comma as they consist of a list.
E.g.
Bell, Book and Candle,
Earth, Wind and Fire
Dave Dee, Dozy, Beaky, Mick & Tich

Would turn into something like "Book Bell and Candle" or "Bell and Candle Book", "Earth, Wind and Fire" into "Wind Earth and Fire" or "Wind and Fire Earth" ...

The easiest way would be to delete all ALBUMARTISTSORT fields and start from scratch. And "scratch" would mean: fill only those ALBUMARTISTSORT fields that really have to be different from the ALBUMARTIST field.

You could filter for files with a starting "The " with
%albumartist% MATCHES "^The "