Remove Carriage Return & New Line from XML file with Powershell Script

Question

Need your help to remove Carriage return (`r) & new line character (`n) from my XML file. I'm getting System.OutOfMemoryException error

The size of File :600 MB

Number of Lines: 1

Input File Format

<File1>
 <SubFile1> </SubFile1>
 <SubFile2> </SubFile2>
 <SubFile3> </SubFile3>
 .........
 <SubFilen> </SubFilen>
</File1>

Code used

$content = [IO.File]::ReadAllText($input_File)
$content = $content.Replace("`r","")
$content = $content.Replace("`n","")
[system.io.file]::WriteAllText($Output_File,$content)

Also tried

Get-Content

I tried with MaxMemoryPerShellMB 1024, 2048, 4096 but no luck.

I'm not getting any error if I execute it from Powershell prompt. C:\Temp\File_Encoding.ps1 "input.xml" "output.xml" I'm getting error when I try to execute like below C:\Windows\syswow64\Windowspowershell\v1.0\Powershell.exe -noprofile -executionpolicy bypass -File "C:\Temp\Change_File_Encoding.ps1" "input.xml" "output.xml" — Praveen
– Praveen, Commented May 17, 2016 at 5:44

Martin Brandl · Accepted Answer · 2016-05-16 08:57:24Z

1

There is a nice article from Don Jones Why Get-Content Ain’t Yer Friend.

Try to use a StreamReader to read the file line by line and use a StreamWriterto write a new (temp) file line by line. After you are finish, just replace the files:

$streamReader = New-Object System.IO.StreamReader -Arg "yourFile.xml"
$streamWriter = [System.IO.StreamWriter] "tmp.xml"

while ($line = $streamReader.ReadLine()) {
  $replacedLine = $line -replace '`r|`n'
  $streamWriter.Write($replacedLine);
}

$streamReader.close()
$streamWriter.close()

Remove-Item "yourFile.xml" -Force
Rename-Item "tmp.xml" "yourFile.xml"

edited May 16, 2016 at 8:57

answered May 16, 2016 at 8:20

Martin Brandl

59.4k16 gold badges151 silver badges190 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Mathias R. Jessen Over a year ago

WriteLine() introduces another newline, defeating the purpose

Martin Brandl Over a year ago

Of course, thanks for the hint. He have to use Write instead - fixed my answer.

Praveen Over a year ago

Still I'm getting the same error.

ERROR encountered - Control has passed to Catch Block Exception of type 'System.OutOfMemoryException' was thrown. Error occurred at line 56

Collectives™ on Stack Overflow

Remove Carriage Return & New Line from XML file with Powershell Script

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related