Quoting Waterman981:

Quote:
I searched and couldn't find anything about this, my search fu is probably broken...

When I do a sort by title, all of the titles with a number at the beginning is only parsed one character, which makes all the titles out of order.  Here's a screen shot:



It should be:

10 Things I Hate About You
50 First Dates
300
2001
2010

Anyone else see this?  Did I miss a discussion about this, or is this something to get fixed?

Titles are sorted by character: "1" is less than "2", so "10" is listed before "2001", and so on.
That's the way it works.
This issues was discussed in the past, try and use Google with "site:invelos.com" if you want to retrieve old threads.

Also sort title for your local is a personal choice, you cannot change the Sort title for the Online database, that is determined by parameters set by Invelos, but your local can and should be sorted according to YOUR parameters.

Skip

Waterman:

It's always worth metioning, you would be surprised what the bad old days were like, with users trying to get the Online to follow the preferences and trying to create sorts James Bond 004 instead of Thunderball. It was a nightmare.

Skip

Quoting Waterman981:

Quote:
I searched and couldn't find anything about this, my search fu is probably broken...

When I do a sort by title, all of the titles with a number at the beginning is only parsed one character, which makes all the titles out of order.  Here's a screen shot:



It should be:

10 Things I Hate About You
50 First Dates
300
2001
2010

Anyone else see this?  Did I miss a discussion about this, or is this something to get fixed?

As a matter of fact it parses all characters, not just the first one. But it handles it as characters, not as numbers, thus "1" comes before "2", even if the whole string is "10" and "2".

I also solved the problem by finding my largest number and filling the others up with leading zeros.

Quoting Jykke:

Quote:
I personally find it quite funny that some people want to sort DVD titles which start with numbers by the number.

Every library I've known handles it that way.

It's the same thing with articles: "a, an, the, eine, der, die, das" are ignored in the sorting. Otherwise a huge part of my collection would be found under "D"

Quoting DJ Doena:

Quote:
Quoting Jykke:

Quote:
I personally find it quite funny that some people want to sort DVD titles which start with numbers by the number.

Every library I've known handles it that way.

I just checked and found that eg. Finnish standard SFS4600 instructs to sort numbers by the numeric order. But still I personally think it is silly and I'm quite happy with the current sorting in DVDP without any leading zeros. However, I wouldn't mind if Ken someday changes this.

Quoting Jykke:

Quote:
Quoting DJ Doena:

Quote:
Quoting Jykke:

Quote:
I personally find it quite funny that some people want to sort DVD titles which start with numbers by the number.

Every library I've known handles it that way.

I just checked and found that eg. Finnish standard SFS4600 instructs to sort numbers by the numeric order. But still I personally think it is silly and I'm quite happy with the current sorting in DVDP without any leading zeros. However, I wouldn't mind if Ken someday changes this.

I wouldn't hold your breath as far as changing thats concerned. In order to change it Ken would have to write his own sort algorithm that would parse the title, find those starting with numbers, convert the String representation of that number to an actual number, sort those numerically first, then take the remaining titles (the ones that don't start with a number) and sort those.

It's wouldn't quite require to passes as you could sort in the current way first, than read through the titles (from start or end, depending on sort order) and once you find one that doesn't start with a number you know the rest won't start with a number so can split the list at that point and resort the first items by their numerical representation (which if their are equals you need to then go to the text, if any, after the number and do it the current way).

It would be similar to having the sort automatically ignore the, a, etc from the start of the titles. Ken currently doesn't do that, he put in the sort title to accommodate that, so I would expect that the sort title would be his answer to these numbers (prepending them with 0's)

I mean, even Microsoft sorts including The, A, etc and treating numbers (10 before 9) as their string and not a number. Thats why you see sequential titles (think tv episodes, comics) numbered 01 and not 1 (or 001).

As interesting as that custom sorting algorithm would be, I'd much rather him spend time on something else...such as custom tabs or a variety of other ideas that have been presented/asked for in the forums.

-Agrare

Quoting Agrare:

Quote:
I wouldn't hold your breath as far as changing thats concerned. In order to change it Ken would have to write his own sort algorithm that would parse the title, find those starting with numbers, convert the String representation of that number to an actual number, sort those numerically first, then take the remaining titles (the ones that don't start with a number) and sort those.

Actually I think it would be fairly trivial to write a comparison operator that handled numbers this way.  Five lines of code or so.  You don't need a new sort algorithm or two passes or anything.  All you need to know is that "20" < "100" < "A".