How do I replace only the second word?

Hi in a text with 2 identical words, how I can replace only the second word?

There may be a way to do it with regex.

Another way would be to use the find() expression to find the first occurrence. Then use the mid() expression to get the text after that occurrence. Next use find() on that again to get the location of the second. Then you could rebuild the text around it.

Basically this. It's untested so there may be a few off by one issues.

Var text="Hi, Bill. My name is Bill."

Var temp=""

Var index=0

Index=find(text, "Bill")

Temp=mid(text, index+len("Bill"), len(text)-index-len("Bill"))

Index=find(temp, "Bill")+index+len("Bill")

Text= left(text, index) & "bob" & mid(text, index+len("Bill"), len(text)-index-len("Bill"))

Thanks works fine

how to replace in a text, this ' by "