Powershell is a free, powerful and handy tool which worths a try and now (since Windows 7) comes bundled with windows.

To replace a set of words with others (in a case sensitive manner) in every files of the current directory and its subdirectory, you may proceed like this:

Get-ChildItem . -Include *.* -Recurse | % {Out-File $_.FullName -Encoding utf8 -InputObject ((Get-Content $_) -creplace('helloworld', 'mystock') -creplace('HelloWorld', 'Mystock') -creplace('HELLOWORLD', 'MYSTOCK'))}

Here, I replace helloworld, HelloWorld and HELLOWORLD with mystock, Mystock and MYSTOCK (respectively). (I set the file encoding to be utf8, which is not required of course)

Published under: SQL Server Tips ·  ·  ·  ·