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)),6," "))

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

« Back to Tech Notes

The [Merge Fields feature]...saved me hours of having to do a bunch of manual address corrections in an updated database, that I already had done months ago on my original database. What a relief. Certainly Rolaids can't top this.
V.J., Los Angeles, CA