Find and replace in XML file with powershell

Question

Right now I am generating an XML file with a GUI using PowerShell Studio 2017. This snippet of code gathers the checked items inside a CheckedListBox:

$Groups = $chklistGroups.CheckedItems | ForEach-Object {
    "<Group>$_</Group>`n`t`t`t`t"
}

Some of these checkboxes contain &, which obviously cannot be inside of an XML file. Is there any way of removing the & and replacing it with the appropriate & within this snippet of code? This XML file is then passed into a different script, where I attempted to remove the ampersands' with this:

# check the xml file for & and replace them with &amp; so it doesn't crash - except it doesn't work so it's gonna crash
if ($NewUserXML.NewUser.ActiveDirectory.User.Groups.Group.Contains("&"))
{
    "$($NewUserXML.NewUser.ActiveDirectory.User.Groups.Group)".Replace('&','&amp;')
}

Is it generally better to do this before the XML is created, or after it's put into the script itself? My assumption is that it's better to do it before it's created. If so, is it possible to do it in that first snippet of code?

G42 · Accepted Answer · 2017-08-10 13:13:24Z

2

You could complete the replace within your ForEach-Object:

$Groups = $chklistGroups.CheckedItems | ForEach-Object {
    "<Group>$($_.Replace('&','&amp;'))</Group>`n`t`t`t`t"
}

answered Aug 10, 2017 at 13:13

G42

10.1k2 gold badges22 silver badges36 bronze badges

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

Collectives™ on Stack Overflow

Find and replace in XML file with powershell

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related