Export the tray and bundle fields without the leading zeros

[Dave]

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