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-boun...@lists.runrev.com on behalf of
use-livecode@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@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
_______________________________________________
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
