rlist sorting upper case vs mixed (OpenInsight 64-bit) [Revelation On-Line Wiki]

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
{{tag>category:"OpenInsight 64-bit" author:"BrianWick" author:"Andrew McAuley" author:"Barry Stevens"}}

[[https://www.revelation.com/the-works|Join The Works program to have access to the most current content, and to be able to ask questions and get answers from Revelation staff and the Revelation community]]


==== rlist sorting upper case vs mixed (OpenInsight 64-bit) ====
=== At 22 OCT 2023 01:39:11PM BrianWick wrote: ===
 
 
<QUOTE>
Still using 10.1

when i do a rlist sorting BY WORDS i get the following:

rlist("LIST WORDSFILE BY WORDS",5)

cccccccc

DVDWarehouse

DiscountDiscount

DiscountTrophy

eeeeeee

ffff



where DVDWarehouse should be after DiscountTrophy



but if i convert everything to upper case for the sake of sorting i get the correct results:

CCCCCCCC

DISCOUNTDISCOUNT

DISCOUNTTROPHY

DVDWAREHOUSE

EEEEEEE

FFFF



so when i sort with mixed upper and lower case it seems to put the upper case ahead of lower case ?



tx

bri


</QUOTE>
----

=== At 22 OCT 2023 02:40PM Andrew McAuley wrote:  ===

<QUOTE>DVD should NOT be after Discount. V has a lower ASCII value than i. 



This is why most indexes convert to uppercase. There is a case-insens keyword I believe but I am away on vacation without my computer, so cannot check this…





[url=https://www.sprezzatura.com]The Sprezzatura Group[/url]

[url=https://www.sprezzatura.com/blog]The Sprezzatura Blog[/url]

[i]World leaders in all things RevSoft[/i]

[img]https://www.sprezzatura.com/zz.gif[/img]

</QUOTE>

----

=== At 22 OCT 2023 03:58PM Barry Stevens wrote:  ===

<QUOTE>
<QUOTE>Still using 10.1

when i do a rlist sorting BY WORDS i get the following:

rlist("LIST WORDSFILE BY WORDS",5)

cccccccc

DVDWarehouse

DiscountDiscount

DiscountTrophy

eeeeeee

ffff



where DVDWarehouse should be after DiscountTrophy



but if i convert everything to upper case for the sake of sorting i get the correct results:

CCCCCCCC

DISCOUNTDISCOUNT

DISCOUNTTROPHY

DVDWAREHOUSE

EEEEEEE

FFFF



so when i sort with mixed upper and lower case it seems to put the upper case ahead of lower case ?



tx

bri

</QUOTE>



Try:



LIST WORDSFILE BY CASEINSENS WORDS



</QUOTE>

----

=== At 23 OCT 2023 02:35PM BrianWick wrote:  ===

<QUOTE>thanks for the obvious guys.

i do a "list"  from tcl and save the results to an excel (or tab) file.

and then open it up in excel.

Its excel that threw me off into a tangent spinning my wheels.

excel automatically applies caseinsens when doing sorting.

tx again guys for chimming in.

bri



</QUOTE>


[[https://www.revelation.com/revweb/oecgi4p.php/O4W_HANDOFF?DESTN=O4W_RUN_FORM&INQID=WORKS_READ&SUMMARY=1&KEY=ADFF9CEC073E1D48B405C252A52AC1A3|View this thread on the Works forum...]]