Sorting an array

[Richard Kreiss]

OK,

To settle this, I took the suggestion of using an external filePro file to the account number's needed for any output.  This option affords me the ability to reload these values for use with another output or delete them if not needed.

As there is a maximum of 20 records consisting of a 4 digit number and one index, this file will not take up much space.

I appreciate all of the suggestions offered.

I do agree that it would be nice to have a function sort(array) with some option similar to building an index. It might look something like this foobar()=sort(array,n,a).  the n for numeric and a for ascending where foobar is the sorted array.

Again, thank you to all those who responded.

Richard Kreiss
GCC Consulting


-----Original Message-----
From: Kenneth Brody [mailto:kenbrody at spamcop.net] 
Sent: Thursday, May 19, 2016 3:00 PM
To: Richard Kreiss <rkreiss at gccconsulting.net>; Filepro List (filepro-list at lists.celestial.com) <filepro-list at lists.celestial.com>
Subject: Re: Sorting an array

On 5/18/2016 12:15 PM, Richard Kreiss via Filepro-list wrote:
 > I would like to be able to sort a 20 element array.
 >
 > Any suggestion as to how best to do this on a Windows machine?

After all the discussion about overhead of external tools, I think a lot of this boils down to how often is this sort going to be done.

There's a world of difference in sorting 20 items once, prior to running a million-record report, and once per record on a million-record report.

--
Kenneth Brody