Sorting search results - solution needed

[Scott Seward]

Hmm, interesting. I'll noodle on that. I also see my email is pretty unreadable without any formatting. Here is a slightly better data example.

Alpha sort
187
187.01
187.02
187.1
187.22
187.234
187.3
187.33
187.456
10187
18700
187 (a)
187 (a)(1)
187 (b)
187 (b)(1)
187.1.1
187.1.2
187.c
187a
187c

Desired SORT

187
187a
187 (a)
187 (a)(1)
187 (b)
187 (b)(1)
187c
187.c
187.01
187.02
187.1
187.1.1
187.1.2
187.3
187.22
187.33
187.234
187.456
10187
18700



On 10/23/18, 12:49 PM, "use-livecode on behalf of Kee Nethery via use-livecode" <use-livecode-bounces at lists.runrev.com on behalf of use-livecode at lists.runrev.com> wrote:

    I’d deconstruct the values into separate items and then sort by the last item, then next to last, eventually getting to the first.
    
    Kee Nethery
    
    > On Oct 23, 2018, at 12:22 PM, Scott Seward via use-livecode <use-livecode at lists.runrev.com> wrote:
    > 
    > Hi,
    > 
    > I need to sort the result set of a search. But the common sort mechanisms I’m familiar with won’t get me where I need. I’m sure this is a common problem and much better developers then I know the name of it and how to execute it in Livecode. Any help would be appreciated. Here is the problem:
    > 
    > I execute a search for “187” and get the following results:
    > 
    > NOTE: The search term will always start with one or more numeric characters and  possibly be  appended by punctuation or other alpha characters.
    > 
    > Alpha sort
    > 
    > Desired Sort
    > 
    > 187
    > 
    > 187
    > 
    > 187.01
    > 
    > 187a
    > 
    > 187.02
    > 
    > 187 (a)
    > 
    > 187.1
    > 
    > 187 (a)(1)
    > 
    > 187.22
    > 
    > 187 (b)
    > 
    > 187.234
    > 
    > 187 (b)(1)
    > 
    > 187.3
    > 
    > 187c
    > 
    > 187.33
    > 
    > 187.c
    > 
    > 187.456
    > 
    > 187.01
    > 
    > 10187
    > 
    > 187.02
    > 
    > 18700
    > 
    > 187.1
    > 
    > 187 (a)
    > 
    > 187.1.1
    > 
    > 187 (a)(1)
    > 
    > 187.1.2
    > 
    > 187 (b)
    > 
    > 187.3
    > 
    > 187 (b)(1)
    > 
    > 187.22
    > 
    > 187.1.1
    > 
    > 187.33
    > 
    > 187.1.2
    > 
    > 187.234
    > 
    > 187.c
    > 
    > 187.456
    > 
    > 187a
    > 
    > 10187
    > 
    > 187c
    > 
    > 18700
    > 
    > 
    > 
    > Kindest regards,
    > 
    > Scott
    > 
    > 
    > _______________________________________________
    > 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
    
    
    _______________________________________________
    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