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've been getting unsolicited comments from clients about your support. They are saying things like, 'Without doubt, the finest software support that I have ever received'. Keep up the good work!
Dealer, Silver Spring, MD