How do i use VB script to change the length of a string in a serial number field
Hi all,
New to VB scripting in Bartender and I'm having trouble trying to apply some code to do the following
We have a serial number field that is 9 digits in length, i need to use the left function to only print the first 7 digits of this field.
We are getting the serial number from an Excel table using a database connection via a form that gets several fields as well as the serial number.
I'd like to be able to change the length of the string from the Excel file from 9 digits to 7 digits, thus only printing the first 7 numbers from the left.
I' am unsure of were to do this and the correct syntax of the code to use.
Some examples or pointers on were to start would be great.
thanks in advance
Trevor
-
No need for VB you can just use one of the Transforms > Truncation settings
0 -
Thanks for the fast reply, that's an excellent suggestion, I'll try it this morning.
regards
Trevor
0
Vous devez vous connecter pour laisser un commentaire.
Commentaires
2 commentaires