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