[solved] ALBUM ARTIST beginning with number

[Dustcap]

This is my first post so: Hi all forum members!  

The A-Z JumpBar is a very useful pre selection tool.
Unfortunately it effects only on the main album list and not on the ColumnBrowser.

So I defined a column called A-Z for the ColumnBrowser: $Left(<Album Artist>,1)
This works as expected for all entries beginning with a letter.
Entries beginning with a number (or other) should be sorted and shown like using the # from A-Z JumpBar.
So there should be # as first entry for ascending sort order followed by A, B, C...

Any help for a custom tag definition is highly appreciated.

[psychoadept]

Hi, welcome to the forum!

So I defined a column called A-Z for the ColumnBrowser: $Left(<Album Artist>,1)
This works as expected for all entries beginning with a letter.
Entries beginning with a number (or other) should be sorted and shown like using the # from A-Z JumpBar.
So there should be # as first entry for ascending sort order followed by A, B, C...

This will work the way you want if you change your formula to:

$Group($Sort(<Album Artist>),1)

The first entry will be "0-9", followed by the letters.

[Dustcap]

Wow, that was fast - and it works perfectly!
Thank you very much, scampbll. 

[psychoadept]

Happy to help! Someone gave me that formula when I first started using MB.