Sorting Columns

dunbarx at aol.com dunbarx at aol.com
Tue Mar 3 09:18:58 EST 2015


An easy way is to extract the full dataset, perhaps with the "dgData". This will give you a tab and return delimited list. Then you might sort by a function:


sort yourData numeric by goodNumber(item columnOfInterest of each)


where:


function goodNumber var
  repeat for each char tChar in var
    if var is in "0123456789" then put tChar after temp
  end repeat
  return temp
end goodNumber


Craig Newman



-----Original Message-----
From: JB <sundown at pacifier.com>
To: How to use LiveCode <use-livecode at lists.runrev.com>
Sent: Tue, Mar 3, 2015 6:33 am
Subject: Sorting Columns


I have a data grid and one of the columns
has numbers with commas included.  If I
use the property  inspector and select the
header column I can choose sort by text
or numeric.  Due to the commas neither
of the sort types gives me a correct sort.

Do I need to make another array and strip
the commas and then use that sort with
columns from the original array?  What is
the best way to sort numeric columns with
commas included in the numbers?

John Balgenort

_______________________________________________
use-livecode mailing list
use-livecode at lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

 



More information about the use-livecode mailing list