The Mid Statement and Function

You’re probably familiar with the Mid function, which returnsa substring of a specified number of characters from its stringargument. But are you aware that Mid can also be used to replacecharacters in the middle of a string? The Mid statement is a bitof an oddity in VB because it alters one of its arguments, butthis saves a lot of string concatenation code:

 Dim Str1 As StringStr1 = "SOME STRING"If Mid(Str1, 2, 1) = "O" _        Then Mid(Str1, _        2, 1) = "A"MsgBox Str1
Share the Post:
Share on facebook
Share on twitter
Share on linkedin

Overview

Recent Articles: