2 Replies Latest reply: May 15, 2014 10:11 AM by Grant Perkins RSS

    USA Zip Code Issue (zip+4 format)

    gpoteet _

      I have a report that shows any zip code with + four as a 9 digit string (without a dash or space.) 

       

      The address is shown on the report in two lines so I use the end of left justification to grab the address.  Then using the address block function I split out the lines and everything is fine if I only have 5 digit zip codes.  But when I have the zip + four in one string the address block can't see that as a zip code.

       

      My only solution I can think is the figure out a calculated field to put the hash mark in the middle of those zip codes.  Any other ideas?

      Thanks!

        • USA Zip Code Issue (zip+4 format)
          elginreigner _

          I would recommend doing what you are suggesting. The Address block function is not 100%, it attempts to separate the address properly but does not always do the greatest job.

            • USA Zip Code Issue (zip+4 format)
              Grant Perkins

              As elginreigner has said the Address 'rules' will sometimes find 'broken' data with which the rules do not work. This is one of the reasons for the Address Block having an error flag option which can be implemented to make identification of problem records much easier. names and address data are often rather poor.

               

              If you can predict, as in this case, that there will be a problem from time to time the easiest way to deal with it is assume that there will always be such a problem. Work out the rules you need to handle the problem and apply them to all records to ceate a suitable calculated field that can then be included in the fields used by the addrss block. Normally you only have to do that analysis work once and can re-use it many times if required. Sometimes you may come across a similar problem that presents a little differently but the chances are that a small adaptation to your original template work will deall with that too.

               

               

              HTH.

               

               

              Grant