Function to Delete Occurrences of a Substring within a String
:
Return to List
Private Function DeleteWithin(ByVal TheString as String, ByVal BadTerm as String)
START_PROCESS:
If InStr(TheString, BadTerm) > 0 Then
OldLength = Len(BadTerm)
TotalLength = Len(TheString)
InnerStringPos = InStr(TheString, BadTerm)
LeftSide = Left(TheString, InnerStringPos - 1)
RightSide = Right(TheString, TotalLength - (InnerStringPos + OldLength - 1))
TheString = LeftSide & RightSide
GoTo START_PROCESS
Else
DeleteWithin = TheString
End If
End Function
Note to Webmaster