Using padleft for varying digit quantities - 5 and 9 digit zipcodes missing leading zeros

[kas]

Hello!

I have a column with zip codes that don't have the leading zeros. I can't use a simple Padleft ([ZIP],5, '0')  because some are only 3 digits 167  missing the leading zeros and some of them have the additional 4 digits, but missing the leading zeros  - for example 9072523 that should be 009072523

Suggestion for the best way to account for both situations?

Thank you!

Kim

[MarqueeCrew · Accepted solution]

@kas ,

Please try this conditional formula:

IF Length([zip]) < 5	Then PadLeft([Zip], 5, "0")
ELSE PadLeft([Zip], 9, "0")
ENDIF

Cheers,

Mark 

[AbhilashR]

@kas - could you give us some sample zip codes and how they are currently structured in your data, and what the output needs to look like? It'll help the community get you exactly what you need.

[kas]

Curent

9072523
731
730
9367113
9695331
9111238
9023557

921

Should be

009072523

00731

00730

009367113

009695331

009111238

00902357

00921

Thanks!

[kas]

This works perfectly! 

Thanks so much!

[AbhilashR]

Thanks @kas. @MarqueeCrew's already posted a solution.