sorting zip codes

Jeanne A. E. DeVoto revolution at jaedworks.com
Mon Jul 11 00:25:10 EDT 2005


At 11:52 AM -0700 7/10/2005, Rich Lague 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.
>
>I tried "sort cards of this stack numeric by chars 1 to 5 of field 
>"zip"" I go a "bad factor" error.

You need to delete the "s":

   sort cards by char 1 to 5 of field "Zip"

"chars" is often synonymous with "char", but not always.
-- 
jeanne a. e. devoto ~ revolution at jaedworks.com
http://www.jaedworks.com



More information about the use-livecode mailing list