sorting zip codes
Dar Scott
dsc at swcp.com
Sun Jul 10 23:30:42 EDT 2005
On Jul 10, 2005, at 5:45 PM, Sarah Reichelt wrote:
>> I’m trying to set up a sort of a stack of address cards by zip code.
>> Some of the zips are only the first 5 numbers and some of them are in
>> the form “xxxxx-xxxx”.
>>
>> The script, “sort cards numeric by field "zip"“ sorts all the 9
>> number zips first, then sorts the 5 number zips-- not what I want.
>
> Untested but worth a try:
>
> set the itemDelimiter to "-"
> sort cards of this stack numeric by item 1 of field “zip”
I wonder if 'sort cards text by field "zip"' would do what is needed.
I would think it would sort like this:
00234
00234-1234
00235
Dar
--
**********************************************
DSC (Dar Scott Consulting & Dar's Lab)
http://www.swcp.com/dsc/
Programming and software
**********************************************
More information about the use-livecode
mailing list