Does VBScript have a substring() function?

Question

Is there a substring() function in VBScript similar to Java's string.substring()?

score 89 · Accepted Answer · edited Oct 19 '11 at 13:37

89

Yes, Mid.

Dim sub_str
sub_str = Mid(source_str, 10, 5)

The first parameter is the source string, the second is the start index, and the third is the length.

@bobobobo: Note that VBScript strings are 1-based, not 0-based. Passing 0 as an argument to Mid results in "invalid procedure call or argument Mid".

edited Oct 19 '11 at 13:37

bluish

26,356
27
122
180

answered Feb 08 '10 at 16:58

Tmdean

9,108
43
51

3

FYI - The third parameter is optional, in which case it will return to the end of the string. – Spongeboy Aug 06 '15 at 05:04
There are also Left() and Right() functions which substring from the left or the right, respectively. I don't know if they would have performance benefits over Mid() or not. – Adam Miller Nov 22 '16 at 15:17

score 13 · Answer 2 · edited May 23 '17 at 10:31

13

As Tmdean correctly pointed out you can use the Mid() function. The MSDN Library also has a great reference section on VBScript which you can find here:

VBScript Language Reference (MSDN Library)

edited May 23 '17 at 10:31

Community

1
1

answered Feb 08 '10 at 17:05

Kev

118,037
53
300
385

Does VBScript have a substring() function?

2 Answers2