VB script + replace word only in specific line

Question

hi

I find way to replace word in text file as the following

strNewText = Replace(strText, "OLD_WORD", "NEW_WORD")t

but this replace every OLD_WORD in the file

my question is if it possible to replace the OLD_WORD with the NEW_WORD only on specific line

for example I want to replace only on line that start with "THIS_LOCATION"

THIS_LOCATION=OLD_WORD

THX for help

Answer 1

Try this:

If InStr(strText, 'THIS_LOCATION') Then
  strNewText = Replace(strText, "OLD_WORD", "NEW_WORD")
End If

The InStr function first checks if the line contains THIS_LOCATION word and if found, it does the replace.