<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<div class="moz-cite-prefix">Hi Jorge,<br>
<br>
My solution: -<br>
<br>
Your data is "Country code", "Town" so: -<br>
<br>
<b><b>Data[0,0] = "US"</b> </b>and<b> <b>Data[1,0] = "New York"</b></b><br>
<b>Data[0,1] = "UK"</b> and <b>Data[1,1] = "London" <br>
</b><b><b>Etc<br>
<br>
</b></b>We want to sort by the "Town" (So we put it first)<br>
<br>
Create a <b>New String[]</b> with "Town" <separator>
"Country Code" <separator> "Town"<br>
<br>
<b>SortList.Add(Data[1,0] & "`" & Data[0,0] & "`"
Data[1,0])</b><b><br>
</b><b>SortList.Add(Data[1,1] & "`" & Data[0,1] & "`"
Data[1,1])</b><b><br>
</b>(use a loop)<br>
<br>
Sort the list<br>
<b>SortList.Sort()</b><br>
<br>
Now rebuild <b>Data</b> with the 2nd and 3rd items<br>
<br>
<b>For iLoop = 0 to ?</b><b><br>
</b><b> Data[iLoop,0] = Split(SortList[iLoop],"`")[1]</b><b> </b>'
"UK"<b><br>
</b><b> Data[iLoop,1] = Split(SortList[iLoop],"`")[2] </b>'
"London"<b><br>
</b><b>Next</b><br>
<br>
See example attached.<br>
<br>
Charlie<br>
<br>
<b><b> </b></b><br>
On 01/12/2018 18:13, Jorge Carrión wrote:<br>
</div>
<blockquote type="cite"
cite="mid:CAOx-q9u08ON+-5uXp3vjOOUO+mx7PosoSXuU6E5BMh6Z8W8G3w@mail.gmail.com">
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
<div dir="ltr">
<div dir="ltr">The problem:<br>
<br>
I need order a bi-dimensional array by several columns
following de user's criteria.<br>
<br>
It is relatively simple to order a two-dimensional array for a
column, not long ago we saw several solutions in this mail
list, but what I need now is to sort by several columns and
that each of them can be ascending or descending.<br>
<br>
I confess that I have been stuck with the subject for four
days, that I have believed more than once that I had solved it
and that in the end I have given up doing it alone. Does
anyone have any idea how to approach the issue before it
drives me crazy?<br>
<br>
There is a "tricky" solution: grab your two-dimensional array,
create with it a sqlite base and let the sqlite engine solve
the issue with an SQL statement ... but this is not the case
(it would force the project to link with the modules database
and it's not always convenient)</div>
<div dir="ltr"><br>
</div>
<div>Waiting for the better minds than mine advice...</div>
<div><br>
</div>
<div>Best Regards<br>
</div>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<pre class="moz-quote-pre" wrap="">
----[ Gambas mailing-list is hosted by <a class="moz-txt-link-freetext" href="https://www.hostsharing.net">https://www.hostsharing.net</a> ]----
</pre>
</blockquote>
<br>
</body>
</html>