Replace a string inside a list of files

Sometimes we need to replace a character string in a flat file.
One possible method could be to use a tool, like notepad++, and open the set of files and use the scan replace options.
But a quick way is again using PowerShell as below:

ls “\cb.n.lo\dfs\reg01\interfaces\T24\From\523.Asn\LU0010001\DOC\NES-TEST\*.xml” -rec | %{ $f=$_; (gc $f.PSPath) | %{ $_ -replace “/Net_Equity_Statement-“, “/NES-” } | sc $f.PSPath }

This will replace the string “/Net_Equity_Statement-” by “/NES” in all *.xml from the directory specified (in my sample it is ” \cb.n.lo\dfs\reg01\interfaces\T24\From\523.Asn\LU0010001\DOC\NES-TEST\”

Here is just another example:
ls *.xml -rec | %{ $f=$_; (gc $f.PSPath) | %{ $_ -replace “<mailingId value=”””, “<mailingId value=””X” } | sc $f.PSPath }

1 Comments

  1. Alex

    Reply

    Nothing to do with programmig tops but very interesting sentense that I read recently.
    ‘When you embrace uncertainty, you open your eyes to new possibilities. You are no longer blinded by your pre-conceptions. Once open to the facts, you can see new opportunities, new solutions’

Leave Comment

Your email address will not be published. Required fields are marked *