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

We really like this software. It is good stuff. I can smile and say that - more than a year after we started using it!
T.M., Charlotte, NC