rlist sorting upper case vs mixed (OpenInsight 64-bit)
At 22 OCT 2023 01:39:11PM BrianWick wrote:
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
At 22 OCT 2023 02:40PM Andrew McAuley wrote:
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…
World leaders in all things RevSoft
At 22 OCT 2023 03:58PM Barry Stevens wrote:
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
Try:
LIST WORDSFILE BY CASEINSENS WORDS
At 23 OCT 2023 02:35PM BrianWick wrote:
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