Support 805.461.7300
Our Technology. Your Success.

Remove Leading Zeros from Address


This command will remove any leading zeros from the address field, e.g. 000345 Main St will convert to 345 Main St. More examples appear below.

The Command At Work

Before Command After Command
Before running command
Before running command

The Command

Copy this command, then paste it into the large text area of the command window:

Replace address with alltrim(str(val(left(address,at(" ",address)))))+substr(address,at(" ",address)) for left(address,1)="0"

After clicking RUN, the leading zeros in the address field will be stripped from the field, and the remainder of the address information will be left justified. Your addresses will now be ready for validation.

« Back to Commands

I just wanted to share how FABULOUS [Geoff] is and you should keep him for sure! I have had the best service and training from him in the last few days that it has sold me on keeping AccuZIP @ my new job. I was new to this software and learning in “trial by fire” mode and he got me thru it without any burns! He is amazing and deserves a raise, bonus, employee of year- SOMETHING BIG. I have dealt with the mail industry for about 30 years and never received this level of support and so positive. I am forever grateful and will suggest him and this product if asked. I am being very serious about his knowledge, skill, and interpersonal skill(hard to find these days).
K.P., Colorado Springs, CO