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

I understand why the USPS needs to change things over time, but since they don't have to deal with customers' software they often don't care about the downstream effects. You guys do a great job on both fronts.
J.P., Greenville, NC