IIUG Software Repository Files

From: sholmes@netcom.com (Scott Holmes)
Newsgroups: comp.databases.informix
Subject: Zip Code Sorting
Date: 12 Nov 1995 19:38:04 -0500

  It was recently requested of me to modify a label printing program
we've had around for a long time (possibly even version 1.0).  We have
a client that does bulk mailings once or twice a year and they want to
take advantage of special rates for sorting by zip code.  I've written
a few functions that satisfy the request but I can see potential for
improvement and increased functionality.  So, if any of you would care
to play with this --- here it is.

   I've made note of some possible enhancements on the other end of
the included code.

Here is a short bit of the output:
#####
Loose Letters for 89119 to 89130  (2 pieces)
Loose Letters for 90000  (2 pieces)
Bundle (5 digits) for 90001 (52 pieces)
Bundle (5 digits) for 90002 (20 pieces)
Bundle (5 digits) for 90003 (39 pieces)
Bundle (5 digits) for 90004 (38 pieces)
Bundle (5 digits) for 90005 (30 pieces)
Bundle (5 digits) for 90006 (54 pieces)
Bundle (5 digits) for 90007 (22 pieces)
Bundle (5 digits) for 90008 (19 pieces)
Loose Letters for 90010  (5 pieces)
Bundle (5 digits) for 90011 (106 pieces)
Bundle (3 digits) for 90012 to 90014  (12 pieces)
Bundle (5 digits) for 90015 (16 pieces)
Bundle (5 digits) for 90016 (25 pieces)
Bundle (5 digits) for 90017 (14 pieces)
Bundle (5 digits) for 90018 (30 pieces)
Bundle (5 digits) for 90019 (36 pieces)
Bundle (5 digits) for 90020 (22 pieces)

Sack (5 digits) for 90021  (130 pieces)

##############

Source code in zip_bundle.4gl


  This is the end of the code.  A couple of improvements would be the
inclusion of sorting by state and controlling the size of sacks.  I'm
not going to include the guidelines provided by the Post Office but
basically they want homogenous sacks of 125 pieces or 15 lbs, and
they want homogenous bundles of ten or more letters.  It would be
nice to control the counters to build sacks of specifics sizes.  This
would change, of course, with variations in letter sizes.

  Well, if anyone wants to play with this here it is.  I'd like to
hear of suggestions for improvements etc, but for now I'm on to other
tasks.



---------- There are more things in heaven and earth, Horatio, ----------------
Scott Holmes            <sholmes@netcom.com>          Informix 4GL Applications
--------------- Than are dreamt of in your philosophy. ------------------------