Confirm sort container order...

[Craig Newman]

Hmmm.

It isn’t that the “D” is concatenated onto the “ABC, (that would never happen)  but rather that the word ”ABC” comes before “AB”, but only if there is a second word in each line:

ABC
AB

Sorts to

AB
ABC

———————

BUT:

ABC XXX
AB XXX

sorts to:

ABC XXX
AB XXX

Not sure I get this.

Craig


> On Mar 30, 2022, at 5:16 PM, Paul Dupuis via use-livecode <use-livecode at lists.runrev.com> wrote:
> 
> On 3/30/2022 4:39 PM, Craig Newman via use-livecode wrote:
>> Paul
>> 
>> I just reread your earlier post. Did you mean concatenating as if each line became a single long word? That would never do, of course, and is not how the line of code works.
>> 
>> 
> 
> This is what I was referring to:
> 
> Input data: (note line 5)
> ABE XYZ GGG
> ACB XYZ GHH
> ABC XYZ DEF
> AAB XYZ GGG
> AB D GHH
> AAA XYZ DEF
> 
> sortlines oftText by word 1 ofeach & word 2 ofeach & word 3 ofeach
> 
> Gives:
> 
> AAA XYZ DEF
> AAB XYZ GGG
> ABC XYZ DEF
> AB D  GHH
> ABE XYZ GGG
> ACB XYZ GHH
> 
> Note line 4 should come before line 3 as "AB" should sort before "ABC" but in the sort above it gets concatenated with the "D" in column 2 to form ABD which places it between ABC and ABE. The concatination can cause errors in the sort order depending upon the actual data being sorted. However, if you sort as follows:
> 
>   sort lines of tText by word 3 of each
>   sort lines of tText by word 2 of each
>   sort lines of tText by word 1 of each
> 
> You get it sorted correctly:
> 
> AAA XYZ DEF
> AAB XYZ GGG
> AB D  GHH
> ABC XYZ DEF
> ABE XYZ GGG
> ACB XYZ GHH
> 
> 
> 
> _______________________________________________
> use-livecode mailing list
> use-livecode at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode