Question:
How can I extract a certain amount of characters from a script’s left or right?
Solution:
To do so, use Left and Right functions to extract characters from the string’s left and right, respectively. Just pass the string and the number of characters to be extracted.
Example:
Dim Word, Left, Right
Word = “Elipse E3”
Left = Left(Word, 6) ‘ Returns “Elipse”.
Right = Right(Word, 2) ‘ Returns “E3”.
MsgBox Left
MsgBox Right