# Artist Sort Query

**URL:** <https://community.mp3tag.de/t/artist-sort-query/51481>\
**Category:** Support\
**Created:** [January 5, 2021, 3:13pm UTC](https://community.mp3tag.de/t/artist-sort-query/51481 "2021-01-05T15:13:30Z")\
**Posts on this page:** 10\
**Page:** 1

<div class="post-metadata">

**Author:** ![IdrisR](https://community.mp3tag.de/letter_avatar_proxy/v4/letter/i/5e9695/32.png) [@IdrisR](https://community.mp3tag.de/u/IdrisR)\
**Post date:** [January 5, 2021, 3:13pm UTC](https://community.mp3tag.de/t/artist-sort-query/51481/1 "2021-01-05T15:13:30Z")

</div>

First Post.  
I need help please (Newbie) how do I get Artistsort to display Surname First, for example Elvis Presley in Artist, Presley, Elvis in Artistsort?

Idiots guide would be very welcome.

Thank You

---

<div class="post-metadata">

**Author:** ![LyricsLover](https://community.mp3tag.de/letter_avatar_proxy/v4/letter/l/c6cbf5/32.png) [@LyricsLover](https://community.mp3tag.de/u/LyricsLover)\
**Post date:** [January 5, 2021, 4:40pm UTC](https://community.mp3tag.de/t/artist-sort-query/51481/2 "2021-01-05T16:40:53Z")

</div>

Do you use any Websources and get this information wrong from (which?) external Sources?

Or do you already have the tag ARTIST filled with "Elvis Presley" and now you want an additional tag ARTISTSORT showing Presley, Elvis?

---

<div class="post-metadata">

**Author:** ![ohrenkino](https://community.mp3tag.de/user_avatar/community.mp3tag.de/ohrenkino/32/4843_2.png) [@ohrenkino](https://community.mp3tag.de/u/ohrenkino)\
**Post date:** [January 5, 2021, 5:07pm UTC](https://community.mp3tag.de/t/artist-sort-query/51481/3 "2021-01-05T17:07:57Z")

</div>

> [@IdrisR](#):
>
> Elvis Presley in Artist, Presley, Elvis in Artistsort

If ARTIST is already filled, try an action of the type "Format value" for ARTISTSORT  
Format string: `$regexp(%artist%,(.*) (.*),'$2, $1')`

If you want to have the same thing with a preview, try Convert\>Tag-Tag with the same parameters.

---

<div class="post-metadata">

**Author:** ![MotleyG](https://community.mp3tag.de/user_avatar/community.mp3tag.de/motleyg/32/440_2.png) [@MotleyG](https://community.mp3tag.de/u/MotleyG)\
**Post date:** [January 5, 2021, 9:30pm UTC](https://community.mp3tag.de/t/artist-sort-query/51481/4 "2021-01-05T21:30:37Z")

</div>

And in addition to the suggested action by @ohrenkino make sure you filter your selection to only include artists with a single "first name" "last name" to ensure you don't apply this to band names, or artists with three names like David Lee Roth. You can apply another filter and a new action as required to fix odd names, or do them manually if it only applies to a few.

---

<div class="post-metadata">

**Author:** ![ohrenkino](https://community.mp3tag.de/user_avatar/community.mp3tag.de/ohrenkino/32/4843_2.png) [@ohrenkino](https://community.mp3tag.de/u/ohrenkino)\
**Post date:** [January 6, 2021, 5:35am UTC](https://community.mp3tag.de/t/artist-sort-query/51481/5 "2021-01-06T05:35:21Z")

</div>

I would not manipulate the artist name at all.  
Just as you pointed out, looking vor David Lee Roth under "Lee Roth, David" would not make much sense.  
But also there are bands that look like a first name/last name but aren't:  
Rolling Stones  
Deep Purple  
Uriah Heep  
Frieda Gold

Then there are groups like "Earth, Wind & Fire", "KC & the Sunshine Band", "Emerson, Lake & Palmer", "Bell, Book & Candle" "Huey Lewis & Then News" - where would you look for them.  
In the end you have such a long list of exceptions that you have "know" each time whether the name got split or not. So I don't think that this method will really lead to a better order.  
I would leave every artist name just as it is with the only exception of band names with articles as first word, e.g. "The Beatles" to "Beatles, The". But even then it could lead to strange results, my favourite: "The The" where it would not change a lot but other groups like "The Band" or "A Flock of Seagulls" - would I really look for them under "B" for "Band" and "F" for "Flock of Seagulls, A"?  
So, keep it as simple as possible would be my guideline.

---

<div class="post-metadata">

**Author:** ![MotleyG](https://community.mp3tag.de/user_avatar/community.mp3tag.de/motleyg/32/440_2.png) [@MotleyG](https://community.mp3tag.de/u/MotleyG)\
**Post date:** [January 6, 2021, 9:39pm UTC](https://community.mp3tag.de/t/artist-sort-query/51481/6 "2021-01-06T21:39:03Z")

</div>

This is fine for the Artist and AlbumArtist tags. But the OP was asking about the sort equivalent tags. These are pretty effective if managed properly. So in a library managed by software that uses sort tags, David Lee Roth would show up as expected sorted as Roth, David Lee and The Beatles would sort as Beatles.

If you were to look for any of these artists in the store, or a library, that is where you would expect to find them.

---

<div class="post-metadata">

**Author:** ![poster](https://community.mp3tag.de/user_avatar/community.mp3tag.de/poster/32/4881_2.png) [@poster](https://community.mp3tag.de/u/poster)\
**Post date:** [January 7, 2021, 5:37am UTC](https://community.mp3tag.de/t/artist-sort-query/51481/7 "2021-01-07T05:37:45Z")

</div>

> [@MotleyG](#):
>
> These are pretty effective if managed properly.

The question is: "What is properly?  
I did this over decades and I always had to look in my list how some special artist names were sorted because I was not certain, how I had decided some years ago.  
i.e.  
Did I decide to sort the band "The Piano has been drinking" under "The" or under "Piano".  
Nowadays I use the sort-tagfields only with classical music for the composers.

My database as a player-basis has a setting with a configurable list which prefixes should not be used for sorting, i.e."The El La Los Las Le Les". In sorting it strips these definitions. And searching the index cares about finding anything anyhow.

My method is far from being perfect but at least it avoids to care about painful decisions how to fill the sort-fields and to remember these decisions. 😉

---

<div class="post-metadata">

**Author:** ![ohrenkino](https://community.mp3tag.de/user_avatar/community.mp3tag.de/ohrenkino/32/4843_2.png) [@ohrenkino](https://community.mp3tag.de/u/ohrenkino)\
**Post date:** [January 7, 2021, 6:24am UTC](https://community.mp3tag.de/t/artist-sort-query/51481/8 "2021-01-07T06:24:06Z")

</div>

> [@MotleyG](#):
>
> But the OP was asking about the sort equivalent tags.

Yes, agreed.  
But ... using the sort fields does not make it any better (IMHO): it will lead to strange appearances in the respective lists.  
I completely agree with @poster when he observes that in the long run you end up with an awful lot of rules to comply with to add new tracks to the collection.  
I, personally, and that is nothing more than my opinion, stick to the simple rule "artist name = brand name". Like I would not look for "General Electric" under "Electric, General" but take the name as it is.  
What should one do about artists like "Martin Solveig" whose real name is Martin Laurent Picandet? Ist that a name to be split? Or is that an artist's brand name?  
Or "Alice Cooper" where the main artist is called Vincent Damon Furnier....  
and loads of other examples.  
So the underlying idea to ease the search does not come to its full blossom.  
In general I think that the problem is not a serious one any more. Most players support a search across all fields. So that whenever I look for "Beatles", I will find "Beatles", "The Beatles" and "Toni Sheridan & the Beatles".

---

<div class="post-metadata">

**Author:** ![MotleyG](https://community.mp3tag.de/user_avatar/community.mp3tag.de/motleyg/32/440_2.png) [@MotleyG](https://community.mp3tag.de/u/MotleyG)\
**Post date:** [January 7, 2021, 3:21pm UTC](https://community.mp3tag.de/t/artist-sort-query/51481/9 "2021-01-07T15:21:29Z")

</div>

Ultimately this is a personal choice. I personally would never sort anything under "The\_" to start (same for any other article A/An/Le/La/etc., as this would make navigating my library extremely unmanageable. The last name, first name sorting is debatable, but to each their own. That is why we have mp3tag! 😀

---

<div class="post-metadata">

**Author:** ![system](https://community.mp3tag.de/uploads/default/original/2X/c/ce7035d426cb755a7916793326d23b465222a407.png) [@system](https://community.mp3tag.de/u/system)\
**Post date:** [February 6, 2021, 3:21pm UTC](https://community.mp3tag.de/t/artist-sort-query/51481/10 "2021-02-06T15:21:30Z")

</div>

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.
