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 wanted to let your team know how much I appreciate you. I'm still fairly new at doing mail data processing, and it if weren't for your active support -- even for the not so smart questions -- I probably wouldn't be doing as well in this job as I am now. I have much more to learn as I have seen, but I just wanted to say thank you for your help! You all are wonderful!
T.B., Greenville, SC