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

Question 1

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

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

1

2

3

4

5

6

7

8

9

10

11

12

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 one file and it worked. However it will create another file:

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

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

Thank you!

Question 2

Try

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

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

Note that the entire file will be read into memory temporarily. If that’s not acceptable, you’ll need to use the pipeline method to write to a new file, then delete the old file, and rename the new file to the old file’s name.

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

Question:

Answer:

Source:

Powershell script to change the format of all files in a folder from Unicode to ANSI by stackoverflow.com licensed under CC BY-SA | With most appropriate answer!

Leave a Reply Cancel reply