how to sort lines with a $ amount

larry at significantplanet.org larry at significantplanet.org
Mon Mar 31 23:20:25 EDT 2014


Thank you everyone for your quick response to my question!


----- Original Message ----- 
From: "Geoff Canyon" <gcanyon at gmail.com>
To: "How to use LiveCode" <use-livecode at lists.runrev.com>
Sent: Monday, March 31, 2014 9:06 PM
Subject: Re: how to sort lines with a $ amount


> No fair, Jacque, I *just* finished testing:
>
> function dollarsAsNumber D
>   if char 1 of D is "$" then return char 2 to -1 of D else return D
> end dollarsAsNumber
>
> gc
>
>
> On Mon, Mar 31, 2014 at 10:02 PM, J. Landman Gay
> <jacque at hyperactivesw.com>wrote:
>
>> On 3/31/14, 9:03 PM, larry at significantplanet.org wrote:
>>
>>> I can sort the lines of the field just fine on word 1 (date),  word 2
>>> (name) and word 3 (number)
>>>
>>> But when I try to sort on word 4, I don't know how to get it to come
>>> out right because the $ in front makes it a string and not a number.
>>>
>>
>> You can sort using a custom function and that's what I'd do here. If the
>> values are in field 1, then:
>>
>> on mouseUp
>>   sort lines of fld 1 numeric by moneySort(each)
>> end mouseUp
>>
>> function moneySort pItem
>>   if char 1 of pItem = "$" then delete char 1 of pItem
>>   return pItem
>> end moneySort
>>
>> Custom function sorting can do all kinds of clever things. The "each" is
>> passed to the function and the sort uses the return value to determine 
>> the
>> final order.
>>
>> --
>> Jacqueline Landman Gay         |     jacque at hyperactivesw.com
>> HyperActive Software           |     http://www.hyperactivesw.com
>>
>>
>> _______________________________________________
>> 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
>>
> _______________________________________________
> 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