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

Thank you for providing such a powerful product! I am so glad I renewed in at the 3-year level. I am amazed at what a difference the ANKlink makes on cleaning client databases.
C.S., Sequim, WA