Fwd: omnisdev-en Digest, Vol 41, Issue 20

Mon Dec 28 17:43:59 EST 2020

Thank you to those who so quickly came to my help.

The thing that worked for me is

Do i_InPortLst.$sort(upp($ref.[L_Name]),kFalse)
Added now to my list of useful things!

Martin

> Message: 1
> Date: Mon, 28 Dec 2020 15:39:34 +0000
> From: Martin Luce <martinluce at eclipse.co.uk>
> To: Omnis List <omnisdev-en at lists.omnis-dev.com>
> Subject: Sorting
> Message-ID: <9EF259F0-412D-4E7C-B775-43050EC06606 at eclipse.co.uk>
> Content-Type: text/plain;	charset=us-ascii
> 
> Hi
> 
> I am trying to sort a list alphabetically but not divided between upper and lower case. ie I want a word starting with lower case c to be in the right place amongst all the Cs and not to have the lower case starting letters appearing after all the upper case first letters.
> 
> I am using 
> 
> Do i_InPortLst.$sort($ref.[L_Name])       L_Name being the name of the column to sort on in the list
> 
> Have tried 
> 
> Do i_InPortLst.$sort($ref.[L_Name],upp())
> but does not help
> 
> Here is to a better New Year for all
> 
> Martin
> 
> ------------------------------
> 
> Message: 2
> Date: Mon, 28 Dec 2020 15:52:17 +0000
> From: Mike Matthews - Omnis <omnis at lineal.co.uk>
> To: OmnisDev List - English <omnisdev-en at lists.omnis-dev.com>
> Subject: Re: Sorting
> Message-ID: <1079A8A8-22C4-459D-92F4-688A774D6F71 at lineal.co.uk>
> Content-Type: text/plain; charset="us-ascii"
> 
> Hello Martin,
> 
> If you make L_Name as a National type.  This will then sort it by AaBbCcDd etc.
> 
> Mike Matthews
> 
> Lineal Software Solutions
> Commercial House, The Strand<x-apple-data-detectors://1/1> Barnstaple, Devon, EX31 1EU<x-apple-data-detectors://1/1>
> 
> omnis at lineal.co.uk<mailto:mike.matthews at lineal.co.uk>
> 
> www.lineal.co.uk<http://www.lineal.co.uk/>
> 
> www.sqlworks.co.uk<http://www.sqlworks.co/>
> 
> 
> 
> On 28 Dec 2020, at 15:39, Martin Luce via omnisdev-en <omnisdev-en at lists.omnis-dev.com<mailto:omnisdev-en at lists.omnis-dev.com>> wrote:
> 
> Hi
> 
> I am trying to sort a list alphabetically but not divided between upper and lower case. ie I want a word starting with lower case c to be in the right place amongst all the Cs and not to have the lower case starting letters appearing after all the upper case first letters.
> 
> I am using
> 
> Do i_InPortLst.$sort($ref.[L_Name])       L_Name being the name of the column to sort on in the list
> 
> Have tried
> 
> Do i_InPortLst.$sort($ref.[L_Name],upp())
> but does not help
> 
> Here is to a better New Year for all
> 
> Martin
> _____________________________________________________________
> Manage your list subscriptions at http://lists.omnis-dev.com
> Start a new message -> mailto:omnisdev-en at lists.omnis-dev.com
> 
> 
> 
> ------------------------------
> 
> Message: 3
> Date: Mon, 28 Dec 2020 10:55:07 -0500
> From: David Barnett <David at FairLibertysCall.com>
> To: OmnisDev List - English <omnisdev-en at lists.omnis-dev.com>
> Subject: Re: Sorting
> Message-ID:
> 	<38ECFB02-4C82-4D86-A3AE-262BD4D7A3DD at FairLibertysCall.com>
> Content-Type: text/plain;	charset=us-ascii
> 
> Worse case is to add a column, write an all upper or lower case copy of the name column and sort on that.
> 
> 
> David Barnett                 David at FairLibertysCall.com
> C: 516-398-8668               www.FairLibertysCall.com
> 
>> On Dec 28, 2020, at 10:52 AM, Mike Matthews - Omnis <omnis at lineal.co.uk> wrote:
>> 
>> Hello Martin,
>> 
>> If you make L_Name as a National type.  This will then sort it by AaBbCcDd etc.
>> 
>> Mike Matthews
>> 
>> Lineal Software Solutions
>> Commercial House, The Strand<x-apple-data-detectors://1/1> Barnstaple, Devon, EX31 1EU<x-apple-data-detectors://1/1>
>> 
>> omnis at lineal.co.uk<mailto:mike.matthews at lineal.co.uk>
>> 
>> www.lineal.co.uk<http://www.lineal.co.uk/>
>> 
>> www.sqlworks.co.uk<http://www.sqlworks.co/>
>> 
>> 
>> 
>> On 28 Dec 2020, at 15:39, Martin Luce via omnisdev-en <omnisdev-en at lists.omnis-dev.com<mailto:omnisdev-en at lists.omnis-dev.com>> wrote:
>> 
>> Hi
>> 
>> I am trying to sort a list alphabetically but not divided between upper and lower case. ie I want a word starting with lower case c to be in the right place amongst all the Cs and not to have the lower case starting letters appearing after all the upper case first letters.
>> 
>> I am using
>> 
>> Do i_InPortLst.$sort($ref.[L_Name])       L_Name being the name of the column to sort on in the list
>> 
>> Have tried
>> 
>> Do i_InPortLst.$sort($ref.[L_Name],upp())
>> but does not help
>> 
>> Here is to a better New Year for all
>> 
>> Martin
>> _____________________________________________________________
>> Manage your list subscriptions at http://lists.omnis-dev.com
>> Start a new message -> mailto:omnisdev-en at lists.omnis-dev.com
>> 
>> _____________________________________________________________
>> Manage your list subscriptions at http://lists.omnis-dev.com
>> Start a new message -> mailto:omnisdev-en at lists.omnis-dev.com 
> 
> 
> 
> ------------------------------
> 
> Message: 4
> Date: Mon, 28 Dec 2020 15:59:23 +0000
> From: Kim Sargent <ksargent at oversiteonline.com>
> To: OmnisDev List - English <omnisdev-en at lists.omnis-dev.com>
> Subject: RE: Sorting
> Message-ID:
> 	<BN6PR17MB31218E86B843705D645DF42BACD90 at BN6PR17MB3121.namprd17.prod.outlook.com>
> 	
> Content-Type: text/plain; charset="us-ascii"
> 
> This works
> 
> Do List.$sort(upp($ref.LastName),kFalse)
> 
> -----Original Message-----
> From: omnisdev-en <omnisdev-en-bounces at lists.omnis-dev.com> On Behalf Of Martin Luce via omnisdev-en
> Sent: Monday, December 28, 2020 9:40 AM
> To: Omnis List <omnisdev-en at lists.omnis-dev.com>
> Cc: Martin Luce <martinluce at eclipse.co.uk>
> Subject: Sorting
> 
> Hi
> 
> I am trying to sort a list alphabetically but not divided between upper and lower case. ie I want a word starting with lower case c to be in the right place amongst all the Cs and not to have the lower case starting letters appearing after all the upper case first letters.
> 
> I am using 
> 
> Do i_InPortLst.$sort($ref.[L_Name])       L_Name being the name of the column to sort on in the list
> 
> Have tried 
> 
> Do i_InPortLst.$sort($ref.[L_Name],upp())
> but does not help
> 
> Here is to a better New Year for all
> 
> Martin
> _____________________________________________________________
> Manage your list subscriptions at http://lists.omnis-dev.com Start a new message -> mailto:omnisdev-en at lists.omnis-dev.com 
> 
> 
> ------------------------------
> 
> Message: 5
> Date: Mon, 28 Dec 2020 08:29:44 -0800
> From: "John Boehme" <john at integralservices.biz>
> To: "'OmnisDev List - English'" <omnisdev-en at lists.omnis-dev.com>
> Subject: RE: Sorting
> Message-ID: <001601d6dd36$a7bc5b40$f73511c0$@integralservices.biz>
> Content-Type: text/plain;	charset="us-ascii"
> 
> Hi Martin,
> 
> Try:
> 
> Do i_lnPortLst.$sort(upp($ref.[L_Name]),kfalse)
> 
> 
> 
> John Boehme
> 940-597-3046
> 
> -----Original Message-----
> From: omnisdev-en [mailto:omnisdev-en-bounces at lists.omnis-dev.com] On Behalf
> Of Martin Luce via omnisdev-en
> Sent: Monday, December 28, 2020 7:40 AM
> To: Omnis List
> Cc: Martin Luce
> Subject: Sorting
> 
> Hi
> 
> I am trying to sort a list alphabetically but not divided between upper and
> lower case. ie I want a word starting with lower case c to be in the right
> place amongst all the Cs and not to have the lower case starting letters
> appearing after all the upper case first letters.
> 
> I am using 
> 
> Do i_InPortLst.$sort($ref.[L_Name])       L_Name being the name of the
> column to sort on in the list
> 
> Have tried 
> 
> Do i_InPortLst.$sort($ref.[L_Name],upp())
> but does not help
> 
> Here is to a better New Year for all
> 
> Martin
> _____________________________________________________________
> Manage your list subscriptions at http://lists.omnis-dev.com Start a new
> message -> mailto:omnisdev-en at lists.omnis-dev.com 
> 
> 
> 
> ------------------------------
> 
> Subject: Digest Footer
> 
> _____________________________________________________________
> Manage your list subscriptions at http://lists.omnis-dev.com
> 
> 
> ------------------------------
> 
> End of omnisdev-en Digest, Vol 41, Issue 20
> *******************************************