I have a label made in Bartender 7.1 that is using a csv text file as a data source. This file is generated each time a box is packed in the warehouse. The file contains ItemName1 through 20 and ItemQty1-20 as individual fields.
When a box only has 3 items in it the label only prints ItemName1 ItemName2 and Itemname3 and the rest are left blank so as not to show on the label and this is what I want. The problem is that ItemQty1 2 and 3 are showing the proper qty but then all the blank ItemQty's (4 - 20) are printing a 0 onto the label.
Is there a way to use VBscript to only print the ItemQty's that are >0 and then blank the rest? I am not too familiar with VBScript I am sure there is a easy answer to this.
Thanks in advance
When a box only has 3 items in it the label only prints ItemName1 ItemName2 and Itemname3 and the rest are left blank so as not to show on the label and this is what I want. The problem is that ItemQty1 2 and 3 are showing the proper qty but then all the blank ItemQty's (4 - 20) are printing a 0 onto the label.
Is there a way to use VBscript to only print the ItemQty's that are >0 and then blank the rest? I am not too familiar with VBScript I am sure there is a easy answer to this.
Thanks in advance