Export Presort Sequence Number without Leading Zeros

Exporting expressions and information including exporting data in presort order or import order, and importing information, along with error messages that may apply to this category.

Moderators: Chrissy, Steve, Terry, Donna, Dave, Eric, MartyH, Kristen, Geoff, Vince

Post Reply
Kristen
Moderator
Posts: 726
Joined: Wed Sep 20, 2006 3:46 pm

Export Presort Sequence Number without Leading Zeros

Post by Kristen » Tue Jun 07, 2011 8:25 am

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

Post Reply