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@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@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@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
