How do i use VB script to change the length of a string in a serial number field

trevor callaghan

• November 19, 2020 00:00

Hi All,

Trying to change the length of my serial number field before printing out the label.

the value is coming from Excel via a user form the length from the Excel file is 9 char and we only need to use the fist 7 char from the left.

I'm assuming the left function will do it but can't figure out were to do this, or the correct syntax.

Any help is appreciated.

Regards

Trevor

0

• 

  Peter Thane

  ★ BarTender Hero ★

  • November 19, 2020 09:05

  You could use the Left VB command but as per your other post the Transforms>Truncation route would be simpler

  

  0
• 

  trevor callaghan

  ★ BarTender Hero ★

  • November 20, 2020 00:05

  I have now tried this and it works perfectly, thanks for your assistance.

   

  regards

  Trevor

  0

Please sign in to leave a comment.