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 just want to tell you how impressed our office is with your staff.
K.M., Decatur, IL