Forum Discussion

leletran's avatar
leletran
Frequent Visitor
3 years ago
Solved

Formatting non-US zip codes

Hello,   Hope all is well! My apology if this was answered elsewhere. I searched the forum and google'd but was not able to find relevant results. I'm working on a shipment dashboard and we send sh...
Need Help
Tips and Tricks
Tutorial Requests
  • vicky_'s avatar
    vicky_
    3 years ago

    You could try add a calculated column: 
    Formatted ZipCode = IF([CountryColumn] = "United States", format your zip code, [zip code])
    As for how to format the US zip codes, you will probably need to use the RIGHT() or LEFT() functions to grab the right bits before and after the hyphen.

vicky_'s avatar
vicky_
Super User
3 years ago

You could try add a calculated column: 
Formatted ZipCode = IF([CountryColumn] = "United States", format your zip code, [zip code])
As for how to format the US zip codes, you will probably need to use the RIGHT() or LEFT() functions to grab the right bits before and after the hyphen.

  • leletran's avatar
    leletran
    Frequent Visitor
    3 years ago

    Hi Vicky,

     

    Good morning! That worked - you are a genuis! Thank you so much for your time and help! 😁 

     

    The formula: Formatted ZipCode = IF([RecipientCountry] = "United States", CONCATENATE(LEFT([Zip Code],5), CONCATENATE("-", RIGHT([Zip Code],4))), [Zip Code])

     

     

    I hope this helps anyone that want to format US- and non-US zip! Thank you again, Vicky. Have a great rest of your morning and day!

     

    Cheers,

    Lele