Sorting Columns

[JB]

Thank you, for the info and code.

John Balgenorth


On Mar 3, 2015, at 2:16 PM, Geoff Canyon <gcanyon at gmail.com> wrote:

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