Print

Please login or register.
1 Hour 1 Day 1 Week 1 Month Forever
Login with username, password and session length

[chrisjj]

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




?

[AndrewFG]

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.

[chrisjj]

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.

[AndrewFG]

I guess that's No.

There's no harm in asking. Perhaps someone at JRiver will pick this one up..

[MrC]

Create a calculated user field that strips the leading punctuation chars.  Use that in your Sort By definition.

[chrisjj]

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?

[MrC]

See this post:

    http://yabb.jriver.com/interact/index.php?topic=79049.msg536798#msg536798

[chrisjj]

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.