Remove Leading Zeros in Endorsement on Label Template

[Kristen]

To remove the leading zeros from the Cont_Id and Gpb_Id fields in the Endorsement line on a label template in AccuZIP6 5.0, use the following expression for the Endorsement line field in your template:

Code: Select all

ALLT(PADL(transform(val(cont_id)),7," "))+"*"+ALLT(PADL(transform(val(gpb_id)),3," "))+Azendorse

To remove the leading zeros from the Sequence number on the label template use this expression

Code: Select all

Transform(Val(Sequence))

To remove the leading zeros from the tray number and bundle number when exporting the endorsement line, use this expression:

Code: Select all

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

Code: Select all