Stripped 0 from beginning of postal code | Community
Skip to main content
R
rachel2-2
New Participant
January 13, 2017
Solved

Stripped 0 from beginning of postal code

  • January 13, 2017
  • 2 replies
  • 4413 views

I apologize if this has already been answered - wasn't quite sure how to search for it. When we upload postal codes to Marketo via CSV, the file strips leading 0's from all postal codes. Our postal codes are set up as string fields in Marketo to allow international zip codes as well. Does anyone have a way to identify 4-digit postal codes and automatically append a zero out front? I'm thinking we could probably use a webhook service to do this, but I'm hoping for an easier way.

Best answer by Grégoire_Miche2

Hi Rachel,

Go for a webhook platform. Look at:

  • flowboost from Etumos. Contact @Edward Unthank (Etumos)​
  • CalcItNow. Contact @Diederik Martens​
  • Hoosh. Contact Fab Capodicasa
  • BrightHook. Contact Rajesh Talele
  • ...

Some of them will have a free level 1 service that might be just sufficient for this. But if you need some advanced logic (for instance to control the case where the leading 0 is missing vs when it is present, or if you need some country -based logic in a international environement), you might need to go for some advanced / chargeable logic.

-Greg

2 replies

Jessica_Kao3
Jessica_Kao3
New Participant
January 14, 2017

Hi Rachel,

When you format your list in excel, format the cell using custom with the following:

If a range of cells contains both five-digit and nine-digit postal codes (ZIP Codes), you can apply a custom format that displays both types of ZIP Codes correctly. In the Type box, type [<=99999]00000;00000-0000

    SanfordWhiteman
    SanfordWhiteman
    New Participant
    January 13, 2017

    Postal Codes should always be Strings anyway (for exactly this reason, so zeroes aren't trimmed).  In the CSV, if the field is a string field there too, it won't do any trimming.

    I can't think of a way to build a smartlist that will match any 4-character string. You could use a webhook, but for a one-time fixup that's a bit of overkill and I'd export and reimport.

    Josh_Hill13
    Josh_Hill13
    New Participant
    January 14, 2017

    agree, just re-upload with Email Address | Zip Code and ensure the file is correct before you upload. Excel does funny things with zip code when not formatted correctly.

    Terms & ConditionsAccessibility statement

    Loading footer...