Support 805.461.7300
Sales
Our Technology. Your Success.
Tech Notes

Export the Sequence number without leading zeros

In the Export Setup window, select the sequence field

In the Expression column, paste this expression:

ALLT(PADL(TRANSFORM(VAL(sequence)),7," "))

Remember to save the export map when you're finished. Expressions can be copied from one export map to another.

« Back to Tech Notes

As always, thanks for your product. We in the industry TRULY appreciate the fact that YOU get back to us. You have NO IDEA how important that is.
T.G., Berlin, MD