Windows 7 Forums
Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


Windows 7: File Sorting Problem

05 Apr 2010   #11
Bruce Gomes

Windows 7
 
 
Windows Incorrect File Sort

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!


My System SpecsSystem Spec
.
06 Apr 2010   #12
jambooger

Windows 7 Home Premiere x64
 
 

I AGREE. I couldnt have stated it better myself.
My System SpecsSystem Spec
06 Apr 2010   #13
Lordbob75

Windows 7 Ultimate x64, Mint 9
 
 

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
My System SpecsSystem Spec
.

06 Apr 2010   #14
JimLewandowski

 
 

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?
My System SpecsSystem Spec
15 Jul 2010   #15
pietchaki

Windows Seven
 
 

@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.
My System SpecsSystem Spec
15 Jul 2010   #16
pietchaki

Windows Seven
 
 

Quote   Quote: Originally Posted by JimLewandowski View Post
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
.
.
.

My System SpecsSystem Spec
17 Jul 2010   #17
Bruce Gomes

Windows 7
 
 
Importance of Files Sorted in ASCII Sequence

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.
My System SpecsSystem Spec
17 Jul 2010   #18
Lordbob75

Windows 7 Ultimate x64, Mint 9
 
 

Quote   Quote: Originally Posted by Bruce Gomes View Post
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.
That makes sense.

I was just curious.

~Lordbob
My System SpecsSystem Spec
29 Apr 2012   #19
SailorCharles

Windows 7 Home Premium 64bit.
 
 
Windows File Sort Out of Step

Quote   Quote: Originally Posted by Lordbob75 View Post
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


Attached Images
File Sorting Problem-directorylist.jpg 
My System SpecsSystem Spec
03 Mar 2014   #20
SailorCharles

Windows 7 Home Premium 64bit.
 
 

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!
My System SpecsSystem Spec
Reply

 File Sorting Problem




Thread Tools




Similar help and support threads
Thread Forum
Folder's file sorting & view does not get saved
Hello, i've been having a annoying issue which messes my file sorting. Thing's that when i change a folder view, from detailed view to large icons, i close it, open it again and it's on detailed just like before, this issue also affects when sorting the files, from Name to File Type, close...
Customization
Batch File Sorting
Hi Guys, I have collection of 35k lyrics in .txt files. They are all in one folder. Is there a way to sort them all in separate Folders (by Artist name for example) Here is a screenshot, how it looks. Free image hosting for your screenshots + free screen capture tool Thanks in advance
General Discussion
file sorting
I can't seem to get my file folders to sort into catagories . :mad: I want links together, graphics together, word together...etc :cry:
General Discussion
File sorting - limited to one level now?
In Vista, I was able to sort files by date created, highlight the files I want, then sort again by name, and all the files I selected previously would still be highlighted, but now they're in numerical order. Win 7 won't let me apply that second level of sorting. It's either name or date, but not...
General Discussion
File Sorting
I am trying to figure out if it's possible to ignore the articles in a file name (i.e. A, An, The) for sorting purposes. More specifically, I want to organize my music folder and I want the folder for "The Beatles" to sort with the other letter "B" artists instead of with the "T" artists. I...
General Discussion
Sorting problem
i Used to be a xp user a lot. Now from about 2-3 months i m using WINDOWS 7. But there is 1 problem in WINDOWS 7 of which i cant find any solution. Maybe here somebody can answer this. i have problem in sorting order. in xp if there were around 100 folders & if we wanted to GROUP THEM...
General Discussion


Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd

All times are GMT -5. The time now is 01:15.
Twitter Facebook Google+ Seven Forums iOS App Seven Forums Android App