Possible to slightly modify alphabetical sorting order?

Support
1

Hey all,

I had a quick question regarding alphabetical sorting and from my search I don't think it has been previously covered in any other posts.

I noticed that when I sort alphabetically top to bottom (A-Z) the order places names with additional names above/in front of just the plain name.

(For example, "Benny Goodman and His Orchestra" is placed above/before just regular "Benny Goodman" or "Sugar Foot Stomp" is placed above/before just regular "Sugar" or "B.o.B feat." is placed above/before just regular "B.o.B").

Is there any way to slightly modify the alphabetical sorting to only reverse the order for these instances (so that it mimics the sorting order in a player such as MusicBee)? I had thought about using the left count but I think my instances are too variable to be able to write it generically for all the cases.

Appreciate the help.

2

I just renamed one of the entries that I have for "Aural Float" to "Aural Float and it floats" and sorted the column again and the longer entry is now the one closest to the end of the list.
In other words: I cannot reproduce it.
Do you have anything special set in the column definition for "Sort by"?
Or do you have trailing space characters in the data for solo artist?

3

I think that is the issue

When my Sort by for ARTIST has my own personal

%ARTIST%($replace(%TITLE%,'[',_01,'+',_02,'{',_03,'(',_04,'#',_05))

then I have that "wrong" sort order - but when I change it to just plain %ARTIST% then it becomes "strictly" alphabetical

4

Interesting.

Confirmed this does seem to be the cause. I had found a post on the forums previously showing how to modify the "sort by" to remove the "The".

But when I have the sort to remove this, it ends up being the "wrong" alphabetical. If I remove this and re-sort, it is the "correct" alphabetical.

Does this mean it is not possible to have both the "correct" order and a special "sort by"?

5

As soon as you set something to customize the sorting, it is you who has to take care whether that fits.
That is why I asked if you have any traling space characters or something.
Still, Benny Goodman should have sorted correctly.
Perhaps it helps if you show us what you entered as "Sort by " expression.

6

Definitely not the case. I have several columns with custom sorting options, many include multiple tags. For example, this is my sort order for the Album column.
%albumartistsort% %albumsort% %discnumber% %track% %titlesort%

This list as expected, with the "plain name" example you indicated in the OP prior to anything similar with additional text after the same base string.

7

I too have few enhanced Columns. And to differentiate between the normal ones and the ones with modified sort order I have e.g. Column named Artist and Artist +