Sort Numbers as Numeric

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


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

-----Original Message-----
From: omnisdev-en On Behalf Of Kelly Burgess
Sent: Saturday, June 12, 2021 8:47 AM
To: OmnisList <omnisdev-en at>
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

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.

Manage your list subscriptions at Start a new
message -> mailto:omnisdev-en at 

More information about the omnisdev-en mailing list