Sort Numbers as Numeric

Michael Mantkowski michaelj at clientrax.com
Sat Jun 12 12:49:31 UTC 2021


Agree!

Yes, I had started going down the road of creating a Temp Column to pull
only the numeric codes into that I would sort on first.

Your idea is so much cleaner.

*********************************************************************
Michael Mantkowski
ClienTrax Software
1-614-875-2245
*********************************************************************


-----Original Message-----
From: omnisdev-en On Behalf Of Kelly Burgess
Sent: Saturday, June 12, 2021 8:47 AM
To: OmnisList <omnisdev-en at lists.omnis-dev.com>
Subject: Re: Sort Numbers as Numeric

> I never realized you could work a calculation into the $sort like that.

The Omnis core is an elegant piece of work.  Here's to the people who make
the tools.

I've mostly used it with upp() for case-insensitive sorting  -  Do
list.$sort(upp($ref.val),kFalse)

You'll hit a wall with the jst(x,'-8P0') if you have to use 2+ digits with
leading letters, e.g. B1..B25.  Then you'll need a temporary sort column and
code like Bas described.

Kelly
_____________________________________________________________
Manage your list subscriptions at http://lists.omnis-dev.com Start a new
message -> mailto:omnisdev-en at lists.omnis-dev.com 



More information about the omnisdev-en mailing list