Zip Code - maintaining leading zeros

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.

Datasets

Accepted answers

messi007

@lmaughan,

You can use a padleft function 🙂

Attached the workflow.

Hope this helps !

Regards,

PadLeft_20210810.yxmd

All comments

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

@lmaughan,

You can use a padleft function 🙂

Attached the workflow.

Hope this helps !

Regards,

PadLeft_20210810.yxmd

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

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703