Sorting Columns

Geoff Canyon gcanyon at gmail.com
Tue Mar 3 17:16:28 EST 2015


On Tue, Mar 3, 2015 at 8:18 AM, <dunbarx at aol.com> wrote:

> 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
>

It's worth checking, but this might be faster (but less robust):

function goodNumber var
  replace comma with empty in var
  return var
end goodNumber

if that does work, then I'd replace it with a more general function:

function replaceF S,F,R
  replace F with R in S
  return S
end replaceF

and then call it with

sort yourData numeric by replaceF(item columnOfInterest of each,comma,empty)



More information about the use-livecode mailing list