Powershell script change the format of all files in a folder from Unicode to ANSI

Question

Can someone give me a Powershell script that will change the format of all files in a folder from Unicode to ANSI? Here is an example folder structure:

c:\DBObjects +StoredProcs - sp1.sql - sp2.sql - sp3.sql +Views - v1.sql - v2.sql .Functions - fn1.sql - fn2.sql 

I tried the following script for a single file and it worked. However, it will create another file:

 Get-Content sp1.sql -encoding Unicode | Set-Content sp1_Ansi.sql -encoding ASCII 

Thanks!

Answer 1

Try

 Set-Content sp1.sql -Encoding ASCII -Value (Get-Content sp1.sql) 

Please note that the entire file will be temporarily stored in memory. If this is unacceptable, you will need to use the pipeline method to write to the new file, then delete the old file and rename the new file to the old file name.