INTERACT FORUM

Please login or register.

Login with username, password and session length
Advanced search  
Pages: [1]   Go Down

Author Topic: Proper alphabetic sorting on leading punctuation  (Read 2108 times)

chrisjj

  • Citizen of the Universe
  • *****
  • Posts: 750
Proper alphabetic sorting on leading punctuation
« on: January 16, 2014, 09:14:40 am »

Anyone know a way to get proper alphabetic sorting where there is leading punctuation e.g.




?
Logged

AndrewFG

  • MC Beta Team
  • Citizen of the Universe
  • *****
  • Posts: 3392
Re: Proper alphabetic sorting on leading punctuation
« Reply #1 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.

Logged
Author of Whitebear Digital Media Renderer Analyser - http://www.whitebear.ch/dmra.htm
Author of Whitebear - http://www.whitebear.ch/mediaserver.htm

chrisjj

  • Citizen of the Universe
  • *****
  • Posts: 750
Re: Proper alphabetic sorting on leading punctuation
« Reply #2 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.
Logged

AndrewFG

  • MC Beta Team
  • Citizen of the Universe
  • *****
  • Posts: 3392
Re: Proper alphabetic sorting on leading punctuation
« Reply #3 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..
Logged
Author of Whitebear Digital Media Renderer Analyser - http://www.whitebear.ch/dmra.htm
Author of Whitebear - http://www.whitebear.ch/mediaserver.htm

MrC

  • Citizen of the Universe
  • *****
  • Posts: 10462
  • Your life is short. Give me your money.
Re: Proper alphabetic sorting on leading punctuation
« Reply #4 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.
Logged
The opinions I express represent my own folly.

chrisjj

  • Citizen of the Universe
  • *****
  • Posts: 750
Re: Proper alphabetic sorting on leading punctuation
« Reply #5 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?
Logged

MrC

  • Citizen of the Universe
  • *****
  • Posts: 10462
  • Your life is short. Give me your money.
Logged
The opinions I express represent my own folly.

chrisjj

  • Citizen of the Universe
  • *****
  • Posts: 750
Re: Proper alphabetic sorting on leading punctuation
« Reply #7 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.
Logged
Pages: [1]   Go Up