devxlogo

The Mid Statement and Function

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

devx-admin

Share the Post: