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

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 commentaires

0
Avatar
Pete Thane
Actions pour les commentaires Permalien

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

0
Avatar
trevor callaghan
Actions pour les commentaires Permalien

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

 

regards

Trevor

Vous devez vous connecter pour laisser un commentaire.