How to increase or decrease the percentage of XML Attribute Values by regex?

Tư Mã Tần Quảng

For example:

<warrior>
<level agility="50" constitution="75" intelligence="100" strength="120"/>
</warrior>

<mage>
<level agility="75" constitution="50" intelligence="120" strength="100"/>
</mage>

Now, I want to increase “agility” by 20%, “constitution” by 10%, “intelligence” by 20% and “strength” by 10% for “warrior” and do the opposite of “mage”.
I wonder if there are any plugins or methods to do that? When both have about 160 lines.

Alan Kilborn

@Tư-Mã-Tần-Quảng

It’s a common question, to which the answer is probably not.

dinkumoil

@Tư-Mã-Tần-Quảng

This can be done with an XSL transformation. Please follow these steps:

Download msxsl.exe, a command line XSLT processor released by Microsoft, from >>> here <<<, or just google for msxsl.exe.
Create a folder where to put:

your input XML file.
the XSL transformation file (see code below).
the batch script for automating the whole process (see code below).
*.ini files for every user whose data you want to change in the XML file.

Code of the XSL file (save it as e.g. Transform.xsl):

<?xml version="1.0" encoding="utf-8"?>

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

  <xsl:output
    method="xml"
    indent="yes"
    omit-xml-declaration="no"
    encoding="utf-8"
  />

  <xsl:param name="userName"/>
  <xsl:param name="agilityFactor"/>
  <xsl:param name="constitutionFactor"/>
  <xsl:param name="intelligenceFactor"/>
  <xsl:param name="strengthFactor"/>

  <xsl:template match="@*|node()">
    <xsl:copy>
      <xsl:apply-templates select="@*|node()"/>
    </xsl:copy>
  </xsl:template>

  <xsl:template match="level">
    <xsl:choose>
      <xsl:when test="name(..)=$userName">
        <xsl:copy>
          <xsl:apply-templates select="@*"/>

          <xsl:attribute name="agility">
            <xsl:value-of select="@agility * $agilityFactor"/>
          </xsl:attribute>

          <xsl:attribute name="constitution">
            <xsl:value-of select="@constitution * $constitutionFactor"/>
          </xsl:attribute>

          <xsl:attribute name="intelligence">
            <xsl:value-of select="@intelligence * $intelligenceFactor"/>
          </xsl:attribute>

          <xsl:attribute name="strength">
            <xsl:value-of select="@strength * $strengthFactor"/>
          </xsl:attribute>

          <xsl:apply-templates select="node()"/>
        </xsl:copy>
      </xsl:when>
      <xsl:otherwise>
        <xsl:copy>
          <xsl:apply-templates select="@*|node()"/>
        </xsl:copy>
      </xsl:otherwise>
    </xsl:choose>
  </xsl:template>

</xsl:transform>

Code of the batch script (save it as e.g. Transform.cmd). Please note: You have to customize lines 3 to 6 to your needs.

@echo off & setlocal

set "MSXSL=<Path-To-msxsl.exe>"
set "BaseDir=<Path-To-Folder-With-Input-Files>"
set "XMLFile=%BaseDir%\<Name-Of-Your-XML-File>"
set "XSLFile=%BaseDir%\<Name-Of-Your-XSL-File>"

copy "%XMLFile%" "%XMLFile%.bak"

for %%z in ("%BaseDir%\*.ini") do (
  for /f "usebackq tokens=1* delims==" %%a in ("%%~z") do (
    if /i "%%~a" equ "userName" set "UserName=%%~a='%%~b'"
    if /i "%%~a" equ "agilityFactor" set "NewAgility=%%~a=%%~b"
    if /i "%%~a" equ "constitutionFactor" set "NewConstitution=%%~a=%%~b"
    if /i "%%~a" equ "intelligenceFactor" set "NewIntelligence=%%~a=%%~b"
    if /i "%%~a" equ "strengthFactor" set "NewStrength=%%~a=%%~b"
  )

  call :ProcessUser
)

exit /b 0


:ProcessUser
  set "Params=%NewAgility% %NewConstitution% %NewIntelligence% %NewStrength%"
  "%MSXSL%" "%XMLFile%" "%XSLFile%" -o "%XMLFile%" %UserName% %Params%
exit /b 0

Now you can create *.ini files for every user whose data you want to change and store them in the folder you created before. Examples for the *.ini files based on your posting above:

warrior.ini

userName=warrior
agilityFactor=1.2
constitutionFactor=1.1
intelligenceFactor=1.2
strengthFactor=1.1

mage.ini

userName=mage
agilityFactor=0.8
constitutionFactor=0.9
intelligenceFactor=0.8
strengthFactor=0.9

Finally you can double-click the batch script file to do your changes. The script will create a backup of your original XML file with .bak appended to its file name in the same folder.

Alan Kilborn

For the record, the context of the original question was implied to be “within Notepad++” (this is a N++ forum after all).

When I replied with “It’s a common question, to which the answer is probably not” that was of course within that context.

If we were going to take it out of the N++ context, the answer is much broader, as @dinkumoil shows.

dinkumoil

@Alan-Kilborn said in How to increase or decrease the percentage of XML Attribute Values by regex?:

this is a N++ forum after all

You are right, of course. But the XSLT solution provided above could also be used with the XML Tools plugin for Notepad++, thus it would stay in the N++ context. But this variant requires the user to enter the appropriate values for the input parameters into a small input box. That’s the reason why I suggested the msxsl.exe solution.

Tư Mã Tần Quảng

@dinkumoil

Thank alot!