Problem of Replace function.

Question

        Dim str

        str = "aaxxbbxxccxx"

        str = Strings.Replace(str, "xx", "WWW", 7, 1)
        MsgBox(str)

 

The result I expect is : aaxxbbWWWccxx
But I get result : WWWccxx

 

How can I get result I expect by Replace function.

Thanks.

Answer 1

That's the expected behavior. The returned string will start at the given starting index.

The documentation of Strings.Replace says:

The return value of the Replace function is a string that begins at the position specified by Start and concludes at the end of the Expression string, with the substitutions made as specified by the Find and Replace values.

Answer 2

Now I know that it is not a bug.

 

Thanks.