INTERACT FORUM

More => Old Versions => JRiver Media Center 19 for Windows => Topic started by: chrisjj on January 16, 2014, 09:14:40 am

Title: Proper alphabetic sorting on leading punctuation
Post by: chrisjj on January 16, 2014, 09:14:40 am
Anyone know a way to get proper alphabetic sorting where there is leading punctuation e.g.

(http://img267.imageshack.us/img267/1346/regiony.png)


?
Title: Re: Proper alphabetic sorting on leading punctuation
Post by: AndrewFG on January 16, 2014, 10:29:31 am
Anyone know a way to get proper alphabetic sorting where there is leading punctuation e.g.

I have two suggestions; a quick and dirty solution, and the real solution:

1. Quick and dirty: if there is a whitespace character between the leading inverted exclamation mark and the first letter of the word, then you could add the inverted exclamation mark into MC's "list of definite articles to exclude" from sorting. Normally definite articles are words like "the", "a", "le", "la", "les" etc. but you could hijack the same logic to exclude leading punctuation. The only requirement is that there must be whitespace between the character and the word you want to sort on.

2. Real solution: you need to ask the MC guys, (it would normally be Matt), to add leading punctuation marks (inverted exclamation mark, inverted question mark, inverted comma, etc.) to the list of characters that are considered as "leading whitespace" for the purposes of sorting.

Title: Re: Proper alphabetic sorting on leading punctuation
Post by: chrisjj on January 16, 2014, 11:35:55 am
if there is a whitespace character between the leading inverted exclamation mark and the first letter of the word

In no orthography system I know is that true.


2. Real solution: you need to ask the MC guys, (it would normally be Matt), to add leading punctuation marks

I guess that's No.

Thanks Andrew.
Title: Re: Proper alphabetic sorting on leading punctuation
Post by: AndrewFG on January 16, 2014, 02:36:38 pm
I guess that's No.

There's no harm in asking. Perhaps someone at JRiver will pick this one up..
Title: Re: Proper alphabetic sorting on leading punctuation
Post by: MrC on January 16, 2014, 02:53:35 pm
Create a calculated user field that strips the leading punctuation chars.  Use that in your Sort By definition.
Title: Re: Proper alphabetic sorting on leading punctuation
Post by: chrisjj on January 16, 2014, 04:21:45 pm
Create a calculated user field that strips the leading punctuation chars.  Use that in your Sort By definition.

Thanks, but I can find no Sort By definition for a Calculated Data user field. Where is it, please?
Title: Re: Proper alphabetic sorting on leading punctuation
Post by: MrC on January 16, 2014, 04:53:10 pm
See this post:

    http://yabb.jriver.com/interact/index.php?topic=79049.msg536798#msg536798 (http://yabb.jriver.com/interact/index.php?topic=79049.msg536798#msg536798)
Title: Re: Proper alphabetic sorting on leading punctuation
Post by: chrisjj on January 16, 2014, 05:05:40 pm
Ah, I guess you are suggesting an new item on the custom sort menu. That sounds like a good workaround if there is indeed no solution to getting the Name column to sort properly.

Thanks.