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

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

Preparation

Accepted answers

MarqueeCrew

@kas ,

Please try this conditional formula:

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

Cheers,

Mark

All comments

MarqueeCrew

@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.