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

0
Avatar
trevor callaghan

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

2 意見

0
Avatar
Pete Thane
評論操作 永久連結

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

0
Avatar
trevor callaghan
評論操作 永久連結

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

 

regards

Trevor

登入寫評論。