StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<blockquote> <p>So, what XPath function will allow me to replace the 255, for another string? Or do I need something other than XPath for this?</p> </blockquote> <p><strong>XPath is the query language for XML and as such cannot modify an XML document</strong>.</p> <p>In order to modify an XML document one needs to use the programming language (such as XSLT, C#, JS, PHP, ..., etc) that is hosting XPath.</p> <p><strong>Here is a solution, where the hosting language is XSLT</strong>:</p> <pre><code><xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"> <xsl:output omit-xml-declaration="yes" indent="yes"/> <xsl:strip-space elements="*"/> <xsl:param name="pNewLineColor" select="123"/> <xsl:template match="node()|@*"> <xsl:copy> <xsl:apply-templates select="node()|@*"/> </xsl:copy> </xsl:template> <xsl:template match="@F_LINE_COLOR"> <xsl:attribute name="{name()}"> <xsl:value-of select="$pNewLineColor"/> </xsl:attribute> </xsl:template> </xsl:stylesheet> </code></pre> <p><strong>when this transformation is applied on the provided XML document</strong>:</p> <pre><code><MineX STATE="add"> <Desc F_CREATOR="admin" F_ENTRYDATE="2010-12-24" F_HEIGHT="0.875" F_ID="1" F_LEFT="1.15625" F_LINE_COLOR="255" F_FORECOLOR="0"> <F_CUSTOM_BYTES></F_CUSTOM_BYTES> </Desc> </MineX> </code></pre> <p><strong>the wanted, correct result is produced</strong>:</p> <pre><code><MineX STATE="add"> <Desc F_CREATOR="admin" F_ENTRYDATE="2010-12-24" F_HEIGHT="0.875" F_ID="1" F_LEFT="1.15625" F_LINE_COLOR="123" F_FORECOLOR="0"> <F_CUSTOM_BYTES></F_CUSTOM_BYTES> </Desc> </MineX> </code></pre>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload