Export the tray and bundle fields without the 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
User avatar
Dave
Site Admin
Posts: 620
Joined: Wed Sep 20, 2006 3:20 pm

Export the tray and bundle fields without the leading zeros

Post by Dave » Fri Feb 29, 2008 12:02 pm

If you would like to export the Endorsement line without the leading zeros use the expression below in the export screen. Make sure there is a space between the quotes where indicated >>ID)),7," "))<<<

Code: Select all

ALLT(PADL(TRANSFORM(VAL(CONT_ID)),7," ")) +"*"+ALLT(PADL(TRANSFORM(VAL(GPB_ID)),3," "))+PADL(ALLT(ENDORSE),20,'*')  

Sequence number would be as follows:

Code: Select all

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

Post Reply