Skip to Content

What is happening?

Importing address lists that contain ZIP codes that start with a zero can be tricky.  Often, the leading zero will be removed before Postalsoft has a chance to acquire the data.  One example of this is when a list is imported into Excel before being imported into Postalsoft:
image

 

What are the signs?

Missing a leading zero in the ZIP code or delivery point can present different symptoms:

Field

Symptom

ZIP/ZIP+4/5-digit part

  • Pieces dropping out
  • “Unqualified (Failed ZIP Verification)”

ZIP 4-digit add-on

  • Pieces droping out
  • Not receiving automation/saturation rates

DP2

  • Pieces dropping out
  • Not receiving automation/saturation rates

Fixing this with Postalsoft

Fortunately, one can re-add the leading zeroes in Business Edition and DeskTop Mailer.  The first step is to select all the records that are missing a leading zero:

  1. Go to  Records > Select > By Criteria…
  2. Under Field, select the affected field.
  3. Under Match, select shorter than.
  4. In Value:
  5. Field Type

    Example

    Type in the following

    5-digit ZIP

    54601

    5

    4-digit ZIP add-on

    9998

    4

    ZIP+4 with a dash

    54601-9998

    10

    ZIP+4 without a dash

    546019998

    9

    DP2

    22

    2

  6. Click on Insert condition.
  7. Click OK.

 It should look something like this example.  The following criteria will select all the ZIP+4 codes, with a dash, that are missing a leading zero:
image

 

Finally repopulate the zero:

  1. Go to Records > Replace…
  2. At the bottom, choose Selected.  This is important, otherwise we’ll ruin the other records that are well formed.
  3. Under Field, select the field in question.
  4. Under Delete, select Portion.
  5. Enter 0 in From character number
  6. Enter 1 in Number of characters
  7. Under Insert, enter 0.
  8. Check the above steps before pressing OK.

Continuing from our previous example, it would look like this:
image

Conclusion

This method can be used for ZIP codes with various formats and for the delivery point (DP2).  With some creativity, you can use variations of this method to modify other types of data.
image

To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply