Does VBScript have a substring() function?

Question

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

bluish · Accepted Answer · 2011-10-19 13:37:11Z

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, 2011 at 13:37

bluish

27.5k28 gold badges126 silver badges185 bronze badges

answered Feb 8, 2010 at 16:58

Tmdean

9,32945 silver badges51 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Spongeboy Over a year ago

FYI - The third parameter is optional, in which case it will return to the end of the string.

Adam Miller Over a year ago

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.

Community · Accepted Answer · 2017-05-23 10:31:09Z

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, 2017 at 10:31

CommunityBot

11 silver badge

answered Feb 8, 2010 at 17:05

Kev

120k53 gold badges308 silver badges396 bronze badges

Collectives™ on Stack Overflow

Does VBScript have a substring() function?

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related