Replace$ Function
Syntax:
Replace[$](S, Pat,
Rep, [Index], [Count])
Group:
String
Description:
Replace Pat with Rep
in S.
Parameter
Description
S This
string value is searched. Replacements are made in the string returned
by Replace.
Pat This
string value is the pattern to look for.
Rep This
string value is the replacement.
Index This
numeric value is the starting index in S. Replace(S,Pat,Rep,N)
is equivalent to Replace(Mid(S,N),Pat,Rep). If this is omitted use 1.
Count This
numeric value is the maximum number of replacements that will be done.
If this is omitted use -1 (which means replace all occurrences).
See
Also: InStr( ), InStrRev(
), Left$( ), Len(
), Mid$( ), Right$(
).
Example:
Sub Main
Debug.Print Replace$("abcabc","b","B")
'"aBcaBc"
Debug.Print Replace$("abcabc","b","B",,1)
'"aBcabc"
Debug.Print Replace$("abcabc","b","B",3)
'"caBc"
Debug.Print Replace$("abcabc","b","B",9)
'""
End Sub
