Support 805.461.7300
Sales
Our Technology. Your Success.
Tech Notes

Export Presort Sequence Number without Leading Zeros

If you want to export the Sequence number field when exporting a file in Presorted order and you don't want the leading zeros, use the expression below next to the Sequence field in your export setup screen:

ALLT(PADL(TRANSFORM(VAL(sequence)),7," "))

« Back to Tech Notes

AccuZIP has tremendously improved the postal service our clients receive...not to mention the tremendous postage savings available when a mailing list is upgraded by AccuZIP.
J.F., Boston, MA