Zip Code - maintaining leading zeros

[lmaughan]

I am having a problem reading in zip code data into Alteryx.  It is auto assigning the Double value by default which strips the leading zeros from the zip code.  I have tried converting to v_string, but the leading zeros are missing.  How does one keep the leading zeros on a zip code, or put them back on if they have been stripped off by Alteryx?

Thanks in advance for your help.

[atcodedog05]

Hi @lmaughan 

You can use PadLeft() 

PadLeft([Field1, 6, "0") 

Here 6 is the required length. It will add "0"s to bring it to length 6.

Can you provide some sample data and expected zip codes for it.

[messi007 · Accepted solution]

@lmaughan,

You can use a padleft function 🙂

Attached the workflow. 

Hope this helps !

Regards,

[lmaughan]

Thank all for your recommendations -- this works!

[james_swanson]

Hello - when generating CSV files, the file format removes the leading 0's. Is there a way to special format an output so that the text is in zipcode/postcode format?

[squinn95]

Did you find a solution to this? Thanks