Re: Sort collating sequence

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: David Candy (.)
Date: 02/02/05


Date: Wed, 2 Feb 2005 17:16:19 +1100

It is sorting correctly. It is not ASCII.
The system's default behavior is to sort punctuation first, followed by numbers and letters.

-- 
----------------------------------------------------------
http://www.uscricket.com
"VManes" <vmanes@N0SP&Mrap.midco.net> wrote in message news:JqOdnYCE-rMi953fRVn-3A@midco.net...
> None of which answers the question of underscore being sorted out of any 
> commonly understood sequence.
> 
> .
> 
> ***************************
> 
> "David Candy" <.> wrote in message 
> news:eqG3swNCFHA.400@TK2MSFTNGP10.phx.gbl...
> Yes we do.
> 1/ Sort is a win32 program
> 2/ It uses two sorting modes - the sort mode of the user or another which I 
> don't know what it does. [Trying to find how locale affects sorting is very 
> difficult]
> 
>  /L[OCALE] locale            Overrides the system default locale with
> 
> 
> 
>                              the specified one.  The ""C"" locale yields
> 
> 
> 
>                              the fastest collating sequence and is
> 
> 
> 
>                              currently the only alternative.  The sort
> 
> 
> 
>                              is always case insensitive.
> 
> 
> -- 
> ----------------------------------------------------------
> http://www.uscricket.com
> "VManes" <vmanes@N0SP&Mrap.midco.net> wrote in message 
> news:StadnYBBiZdn0Z3fRVn-oA@midco.net...
>> The out of sequence use of the "_" character is probably a Microsoftism -
>> this lets you force a directory (folder) or filename to be sorted before
>> similar named ones in directory/folder views.  I use this a lot to put a
>> folder I want up front to be there, without having to give it a different
>> name.
>>
>> Or, it's really and undocumented change to a minimally documented aspect 
>> of
>> the sort.exe program.  In the MS-DOS Encyclopedia (1988), "...with 
>> versions
>> 3.0 and later, SORT assigns lowercase letters the same ASCII value as
>> uppercase letters; hence, case is effectively ignored."
>> Perhaps someone revised to code to treat uppercase by their lowercase
>> equivalent?  NO, I don't think it's that, because the underscore is also
>> collated before digits, which is way out whack with ASCII.
>>
>> It's just an M$ thing - no one understands!
>>
>> Val
>>
>> ***************************
>>
>> "Bractals" <Bractals@discussions.microsoft.com> wrote in message
>> news:FB38B31C-6B87-495D-812D-615C8CBA2E0B@microsoft.com...
>> The following file segments were sorted with
>> qsort.exe (an old DOS program) and Windows
>> sort.exe program. Note that sort.exe has
>> the underscore '_' before the letters 'C'
>> and 'S'. This does not conform to ASCII.
>>
>>          Qsort.exe Collating Sequence
>>
>> C:\DELL\ALERT\
>> C:\DELL\ALERT\0 \
>> C:\DELL\ALERT\0\+CCC.GIF
>> C:\DELL\ALERT\0\+___.GIF
>> C:\DELL\ALERT\0\10675121.GIF
>> C:\DELL\ALERT\0\ALERT.GIF
>> C:\DELL\ALERT\0\OFFDELL.GIF
>> C:\DELL\ALERT\0\PRIVACYSEAL.GIF
>> C:\DELL\ALERT\0\PRIVACY_CONTENT.HTM
>> C:\DELL\ALERT\0\RELIABILITYSEAL.GIF
>>
>>          Sort.exe Collating Sequence
>>
>> C:\DELL\ALERT\
>> C:\DELL\ALERT\0 \
>> C:\DELL\ALERT\0\+___.GIF
>> C:\DELL\ALERT\0\+CCC.GIF
>> C:\DELL\ALERT\0\10675121.GIF
>> C:\DELL\ALERT\0\ALERT.GIF
>> C:\DELL\ALERT\0\OFFDELL.GIF
>> C:\DELL\ALERT\0\PRIVACY_CONTENT.HTM
>> C:\DELL\ALERT\0\PRIVACYSEAL.GIF
>> C:\DELL\ALERT\0\RELIABILITYSEAL.GIF
>>
>> Bractals
>>
>>
>> "VManes" wrote:
>>
>>> What makes you think it's not doing ASCII based sorting?  Please provide 
>>> a
>>> sample input and output, and point out what's wrong.
>>>
>>> val
>>> -- 
>>> ~~~~~~~~~~~~~~~~~~~~~~~~~~~
>>> www.sdsmt.edu
>>> The best little engineering school you
>>> may not have heard of, but should have!
>>> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>>> "Bractals" <Bractals@discussions.microsoft.com> wrote in message
>>> news:96807CAA-10E4-4D2D-9E71-5001482C9DC0@microsoft.com...
>>> I used the sort.exe command at the command prompt. The collating sequence
>>> does not seem to conform to ASCII. Does anybody know how to force the 
>>> sort
>>> command to conform to the ASCII collating sequence?
>>>
>>>
>>>
>>
>> 
> 
>


Relevant Pages

  • Re: Sort collating sequence
    ... To paraphrase a former leader of the free world, define "sorting correctly". ... is represented by the character coding scheme, generally ASCII. ... the underscore falls between the upper and lowercase letters. ... The sort utility on my Linux box sorts in that same manner. ...
    (microsoft.public.windowsxp.help_and_support)
  • Re: Sort collating sequence
    ... 2/ It uses two sorting modes - the sort mode of the user or another which I don't know what it does. ... NO, I don't think it's that, because the underscore is also> collated before digits, which is way out whack with ASCII. ...
    (microsoft.public.windowsxp.help_and_support)
  • Re: Excel sort ( exclude letters include hyphens)?
    ... after sorting according to your rules? ... What was asked of me is to sort the list so that letters are not taken into ... consideration and so that it is sorted by the number of digits to the left of ...
    (microsoft.public.excel.worksheet.functions)
  • Re: How do I sort Mac and Mc together alphabetically?
    ... Please sort the following names into correct order then: ... use this calculated field for sorting. ... to begin with the letters "Mac" will be sorted incorrectly, ...
    (microsoft.public.access.gettingstarted)
  • Sorting lists of Named Ranges
    ... Create a sheet with the letters A, B, C, D, E, F in column A, rows 1-6 ... Now sort on it descending - and it comes out A, E, D, C, B, F ?! ... I've also noticed that if you repeat sorting enough times, ...
    (microsoft.public.excel.programming)