replace last instance of a substring only 2

[myatia]

What's the easiest and most efficient way to replace only the last instance of a substring? For example, how do I change the last instance of "dog" into "cat":

before = "My dog chased this dog and that dog."
after = "My dog chased this dog and that cat."

If anyone has any suggestions, I'd really appreciate them.

Thanks!

Misty

 

[simonchristieis]

Something like

myString = "My dog chased this dog and that dog."

response.write Left(myString, InStrRev(myString ,"dog&quot-1) & Replace(myString ,"dog","cat",InStrRev(myString ,"dog&quot)


hth

simon

 

[modalman]

Try something like this:

myStr="My dog chased this dog and that dog."
targetStr="dog"
swapStr="cat"

ix=InStrRev(myStr,targetStr)
If ix>0 Then myStr=Left(myStr,ix-1) & Replace(Mid(myStr,ix),swapStr)



ASCII silly question, get a silly ANSI

 

[simonchristieis]

hmmm - what do they say about brilliant minds?

identical code - well almost