Updating an xsl:variable in an .xslt file using Powershell

Question

I have an .xslt file with just a few variables in it. I need to update two of them using Powershell. The file looks like:

 <xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">

<xsl:variable name="VarA" select="this data stays the same" />
    <xsl:variable name="VarB" select="this data also stays the same" />

    <xsl:variable name="ChangeMe_1" select="data to be changed" />
    <xsl:variable name="ChangeMe_2" select="more data to be changed" />

 </xsl:stylesheet>

I need to update the select values in the variables named ChangeMe_1 and ChangeMe_2 to parameters passed into the Powershell script. I'm a total newbie at Powershell, and I'm finding lots of resources on parsing XML files, but this xslt is just different enough that it's confounding me.

Additionally, this needs to be done in every .xslt file with the same name in a hierarchy of folders, so if anyone can point me in the right direction for that I'd very much appreciate it.

Loïc MICHEL · Accepted Answer · 2013-01-25 14:28:16Z

2

treat your file as xml :

[xml]$t=@(gc C:\temp\test.xslt)
$t.stylesheet.variable | ?{$_.name -like "ChangeMe_1"}|%{$_.select="New Value"}
$t.Save("newname.xslt")
gc .\newname.xslt

<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
  <xsl:variable name="VarA" select="this data stays the same" />
  <xsl:variable name="VarB" select="this data also stays the same" />
  <xsl:variable name="ChangeMe_1" select="NewValue" />
  <xsl:variable name="ChangeMe_2" select="more data to be changed" />
</xsl:stylesheet>

answered Jan 25, 2013 at 14:28

Loïc MICHEL

26.3k10 gold badges79 silver badges111 bronze badges

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

8 Comments

BDW Over a year ago

The save doesn't seem to work - that last line fails and tells me it can't find "newname.xslt" and indeed, it's not there.

Loïc MICHEL Over a year ago

try to specify complete path $t.save("c:\temp\newfile.xslt") I've tested both in V2 et V3

BDW Over a year ago

Yay! That worked, but ultimately I need the path to be dynamic - this needs to be run on an entire folder hierarchy, updating all files anywhere in the hierarchy with the same name, and the root folder will change as well. Any ideas?

Loïc MICHEL Over a year ago

try : $files=ls $mypath -Filter "*.xslt" -Recurse; $files |%{ [xml]$t=(gc $_.fullname) ... }

BDW Over a year ago

Now it's asking me for parameters, like so: cmdlet ForEach-Object at command pipeline position 1 Supply values for the following parameters: Process[0]:

|

CB. · Accepted Answer · 2013-01-25 14:56:12Z

1

Something like this, I suggest to test it in a test folder before run it in production:

param ($path, $filename, $newvalue)

$files = dir $path -filter $filename -Recurse
foreach ($file in $files)
{
[xml]$xml= gc $file.fullname
$xml.stylesheet.variable | ? { $_.name -match 'ChangeMe_[1|2]' } | % {$_.select= $newvalue }
$xml.Save($file.fullname)
}

edited Jan 25, 2013 at 14:56

answered Jan 25, 2013 at 14:19

CB.

61.3k9 gold badges171 silver badges165 bronze badges

1 Comment

BDW Over a year ago

Perfect, completely does the job. Thanks.

Collectives™ on Stack Overflow

Updating an xsl:variable in an .xslt file using Powershell

2 Answers 2

8 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

8 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related