Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Bartender VBscript to strip 0 qty from a label

Status
Not open for further replies.

wsteve

Technical User
Jan 25, 2010
1
0
0
CA
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top