Paul,

Many many years ago, I wrote a package that translated four 30 byte fields
into zip, state (spelled out, abbreviated, mis-abbreviated).  It was not
elegant, but it worked.  It used compile time tables, but I got a 99+ hit
rate after a few passes.  It allowed for both 5 and 9 digit zip codes (with
or without the dash).

Barfed a bit over English and Canadian postal codes, but had a decent paper
audit trail.  (Both all and errors only)

Alas I wrote it for for RPG II, but I may have updated it to III.  I'd
check, but my @#$%ing HMC has all my partitions down at the moment.

Please call privately.  You know the work and home numbers.

Al

Al Barsa, Jr.
Barsa Consulting Group, LLC

400>390

"i" comes before "p", "x" and "z"
e gads

Our system's had more names than Elizabeth Taylor!

914-251-1234
914-251-9406 fax

http://www.barsaconsulting.com
http://www.taatool.com
http://www.as400connection.com



                                                                           
             pnelson@xxxxxxxxx                                             
             m                                                             
             Sent by:                                                   To 
             midrange-l-bounce         MIDRANGE-L@xxxxxxxxxxxx             
             s@xxxxxxxxxxxx                                             cc 
                                                                           
                                                                   Subject 
             01/28/2005 08:13          Zip code translation                
             AM                                                            
                                                                           
                                                                           
             Please respond to                                             
             Midrange Systems                                              
                 Technical                                                 
                Discussion                                                 
             <midrange-l@midra                                             
                 nge.com>                                                  
                                                                           
                                                                           




<FONT face="Default Sans Serif, Verdana, Arial, Helvetica, sans-serif"
size=2><DIV>I'm at a client doing a conversion from one software package to
another. The old package has a combined city/state field. The new package
has the city and state separated into two fields. Does anybody have a table
that would help me to derive the state based on the zip
code?</DIV><DIV>&nbsp;</DIV><DIV>Please send it to my private email address
since this list does not permit attachments. This is a V5R2
system.</DIV><DIV>&nbsp;</DIV><DIV>Thanks<BR><BR>Paul&nbsp;Nelson<BR>Arbor&nbsp;Solutions,&nbsp;Inc.<BR>708-670-6978&nbsp;&nbsp;Cell<BR>pnelson@xxxxxxxxxx<BR><BR></DIV></FONT>--

This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.




As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.