Add starting zero to 5 digit numbers (when 6 digits are necessary)

Gerard_Spijker — Wed, 05 Mar 2025 07:37:19 GMT

Dear community, I am looking for a formula to enforce for a field that six digits are in a field. When there are 5 digits, then a zero gets added at the front.

Thanks!

Re: Add starting zero to 5 digit numbers (when 6 digits are necessary)

AnthonyValidity — Wed, 05 Mar 2025 14:58:36 GMT

Hi @Gerard_Spijker ,

Thank you for reaching out via the Validity Customer Community. This could be accomplished in the Modify module using the Modify Action "Formula".

Here is an example using the Account Object and modifying the Billing Zip Code. You would replace the fields names in this formula with the field you're using.

IF(LEN(${BillingPostalCode})=5, "0" & ${BillingPostalCode}, ${BillingPostalCode})

IF(condition, value_if_true, value_if_false) - This is using an IF statement to make a decision based on a condition.
LEN(${BillingPostalCode})=5 - The condition checks if the length of the billing postal code is exactly 5 characters.
If the postal code is exactly 5 characters long, it adds a "0" in front of it: "0" & ${BillingPostalCode}
If the postal code is NOT 5 characters long, it just uses the postal code as is: ${BillingPostalCode}

Best,

Re: Add starting zero to 5 digit numbers (when 6 digits are necessary)

Gerard_Spijker — Mon, 10 Mar 2025 08:42:10 GMT

Perfect! Much appreciated. 😉

topic Re: Add starting zero to 5 digit numbers (when 6 digits are necessary) in DemandTools

Add starting zero to 5 digit numbers (when 6 digits are necessary)

Re: Add starting zero to 5 digit numbers (when 6 digits are necessary)

Re: Add starting zero to 5 digit numbers (when 6 digits are necessary)