Page 1 of 1

Export Presort Sequence Number without Leading Zeros

Posted: Tue Jun 07, 2011 8:25 am
by Kristen
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:

Code: Select all

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