' Check for the last occurrence If Mid(loStringBuilder.ToString, loStringBuilder.Length - lcWord.Length) = "." + lcWord Then loStringBuilder.Remove(loStringBuilder.Length - 1 - lcWord.Length, lcWord.Length) loStringBuilder.Append("[" + lcWord + "] ") End If ' Check for the first occurrence If Mid(loStringBuilder.ToString, 1, lcWord.Length + 1) = lcWord + "." Then loStringBuilder = oApp.StuffFromStringBuilder(loStringBuilder, 1, 1, "[") loStringBuilder = oApp.StuffFromStringBuilder(loStringBuilder, lcWord.Length + 2, 1, "]") End IfThe Stuff is an equivalent of VFP Stuff command:
' Equivalent of VFP Stuff but for a StringBuilder() ' expO1 StringBuilder ' expN1 Start of replacement ' expN2 Number of characters to be replaced ' expC2 Replacement character expression Public Function StuffFromStringBuilder(ByVal toStringBuilder As StringBuilder, ByVal tnStartReplacement As Integer, _ ByVal tnCharacterReplaced As Integer, ByVal tcReplacement As String) As StringBuilder ' First remove the characters specified in nCharacterReplaced If tnCharacterReplaced <> 0 Then toStringBuilder.Remove(tnStartReplacement - 1, tnCharacterReplaced) End If ' Now Add the new string at the right location ' sb.Insert(0,cExpression,nTimes) toStringBuilder.Insert(tnStartReplacement - 1, tcReplacement) Return toStringBuilder End Function