How to remove special characters while saving xml string using Powershell

Question

Following is the powershell code which I am using to remove parent node from the web.config file:

 $c = "C:\test\web.config"
     $xml = ( Get-Content $c)
     $ConnectionString = $xml.configuration.appSettings.add | Where-Object {$_.Key -eq 'ConnectionString'}
     $xml.configuration.RemoveChild($ConnectionString.ParentNode)
     $xml.save($c)

After removing <appSettings> tag from web.config file. Some special Characters like &#xA; are adding to web.config file as below:

<?xml version="1.0"?>
<configuration xmlns="http://schemas.microsoft.com/.NetConfiguration/v2.0">
  <configSections>
    <sectionGroup name="system.web.extensions" type="System.Web.Configuration.SystemWebExtensionsSectionGroup, &#xA;        System.Web.Extensions, Version=3.5.0.0, Culture=neutral, &#xA;        PublicKeyToken=31bf3856ad364e35">
   </configSections>
</configuration>

Please let me know how to save xml file without special characters like 
 and new line

Naigel · Accepted Answer · 2015-03-31 15:17:50Z

1

Just had this issue, I filtered all non ascii-256 chars with this regex

$myText = # your text here
$cleanText = ($myText -replace"[^\x00-\xFF]","");

Are you sure this chars should be removed? You can also try to change encoding with something like this

$myText | Out-File -FilePath "yourPath" -Encoding utf8

edited Mar 31, 2015 at 15:17

answered Mar 31, 2015 at 12:13

Naigel

9,76417 gold badges73 silver badges111 bronze badges

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

1 Comment

Praveen Over a year ago

I have used both [^\x00-\xFF] and utf8 encoding for xml file still same special characters i.e, 
 and 
 are coming instead of white spaces

Collectives™ on Stack Overflow

How to remove special characters while saving xml string using Powershell

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related