File Sorting Problem

Thank you very much everyone for taking the time to respond. I may disagree, but I respect your responses. Nonetheless, do you really believe that this is the correct way to sort the files? Windows has it right and every other system has it wrong, including older Windows systems? Yes, I really do understand, Microsoft feels their way is better, and they are doing it intentionally, and hence, yes, THEY feel it's correct. Yes, I know how it works. Well, software I have depends on the order being the OTHER way it works on *every* other system. I haven't had anyone tell me that the list I sent with the new sort makes any sense. I also gave a similar lists to dozens of technical computer professionals (all 20+ years experience, all six figure salaries, all UNIX SA's, Windows SAs, systems programmers, DBAs) and none of them have been able to sort it like Microsoft sorts it - in fact most don't even believe me until they try it (I was even thrice accused of pulling an April Fool's joke on them). I have tens of thousands of files with this naming convention. Most of the files have numeric names, and some have the eighth character replaced by an alphabetic. I need the original order. Microsoft should provide a way to sort it as they always have, and as every other operating system sorts it, and not pretend they have a better way. For my list of files the Microsoft sort clearly makes no sense. If Microsoft has the audacity to insist on this new default, they should at least have the decency to provide a way to undo this mess. I've seen ways to update the registry with some versions of Windows to undo this sort methodology, but nothing definitive for Windows 7. So... that is simply what I seek; a way to update Windows 7 to return to a normal ASCII sort on file names, like every other system does it. Thanks!

I AGREE. I couldnt have stated it better myself.

Interesting someone brought this up.

W7 sorts:

jl0327a2010.csv
jl0327b2010.csv
jl01012010.csv
.
.
.
.
.
jl03272010.csv
.
.
.

Why are the jl0327a/b files at the top when they should be next to the jl03272010 below?

@Bruce Gomes: I think the sorting in you files is OK, cause "C:\windowsbug\00100000000.txt" (number value = 100.000.000) is grater than "C:\windowsbug\66666666.txt" (number value = 66.666.666)

But, can someone try to explain me why my files are sorted this way:
My folder of Images:


in this case, the sorting sistem "think" that number 2 is grater than 2.3... kinda shit.
in Windows XP and in my Ubuntu 10.04 its sorted like this:

img
img1
img2
img2.1
img2.2
img2.3
img3
img3.1
img3.1.1
img3.2
img4
img5

I think the sorting sistem read the first dot as the end of the file name, and then sort by the suffix, in this case ".1" is less then ".jpg".
This sorting sistem is the oly thing I don't like in Seven. Micro$$oft must fix that nonsense fail.

JimLewandowski said:

Interesting someone brought this up.

W7 sorts:

jl0327a2010.csv
jl0327b2010.csv
jl01012010.csv
.
.
.
.
.
jl03272010.csv
.
.
.

Why are the jl0327a/b files at the top when they should be next to the jl03272010 below?

Seven try to order by the number instead of ASCII code of each character, so 3.272.010 is Much higher than 327

it's part of the solution to resolve number sorting in this:

1
10
11
12
13
2
20
21
3
4
5
51
.
.
.

Lordbob inquired;

Also, why does it matter what order the files are SORTED in? (admittedly I am not a programmer, this is a real question) Theoretically, you just call the file name in the program, and file path, why does sorting matter?

Two reasons;
1) Programatically, many programs read through thousands of files, not just one file, and you supply the file system that contains them. Programs will often assume they can access the files in ASCII name order (or EBCDIC order on other systems!) or more importantly requires the operating system to supply them in ASCII order when the call a function to supply a list of file names or simply when they read the list of files. This is the way some utilities worked, and it's the way some older "pre-relational" database systems worked. Think of each file as one record in the database.
2) From a non-programming perspective, my files under ASCII sort are in perfect order, and logically I often need to access multiple files that would normally be adjacent. If they are not adjacent I have no way of knowing if the other files even exist to know to look for them (they don't have to exist, the files are all logically related and all optional) If a file system has ten files this doesn't matter much, if it has ten thousand files it's simply a catastrophe.

Lordbob75 said:

Did you not read what Dzomlija said?

Windows sorts it by ASCII code number.....

Also, why does it matter what order the files are SORTED in? (admittedly I am not a programmer, this is a real question) Theoretically, you just call the file name in the program, and file path, why does sorting matter?

~Lordbob

You asked "Why Does Sorting matter?"

This reply (I hope) will give you a working example why.

When working as a group which expects to exchange files there has to be agreement on a filenaming convention. That convention has to cater for a host of requirements (All well covered elswhere on the web and assumed knowledge as far this reply is concerned).

The files that are "exchanged" also serve as an "Audit Trail". Therefore the use of PDFs provide a reasonable choice of "that which was sent".

I first produce the document in Word and then I "Save and Send" / "Create PDF/XPS Document. This produces two files on my drive with identical file names differing only by their .xxx extnsions.

The Word version is no longer required ~ the PDF is "the record to keep" . . . . Before win7 "new improved" sorting both files fell together on the screen. Now they are widely separated which makes it difficult easily to spot which one to delete when conducting a "clean-up".

Furthermore, the recipient(s) save the files and they appear in an appropriate order on their machines too. (Except if they have the misfortune to have win7)

(Please see the edited screen shot ~ as you may gather, the documents relate to a Club activity and we use various "Forms" to pass information.)

Red Herring warning ~ Please do not suggest that we rename our files . . . . What we have works across a number of platforms.

(The hidden request is "How can this perverse sort be "unwound" in win7?")

Thank You
Sid

I may well have found an answer to this perverse issue.

Many thanks are owed to:

Windows 7 Explorer Sort order

Which is a link to:
alliancegroup . co . uk technical help pages

Red Herrings:

There are a number of fixes available through the group policy editor (!) In my case (Win 7 Home premium 64bit) I am not allowed to use it! . . . therefore I have tried the "Registry fix" at the above link.

Again, (presumably because I only have Home Premium) the Dword "NoStrCmpLogical" did not exist!
I created it and gave it the value of 1.

For the very busy reader, the relevant part of the above link is:

Alternatively you can change the setting in the Registry database:

To turn off numerical sorting:
In [HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Policies\Explorer]
Set NoStrCmpLogical to 1 - that is: "NoStrCmpLogical"=dword:00000001

It seems to work! :)