StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<p>To do this using only <strong>one</strong> transform process would require your newly created show elements to be seen as a <strong>node-set</strong> so the templates can use the internal <strong>xsl:sort</strong> mechanics. The <a href="http://www.w3.org/TR/xslt" rel="nofollow noreferrer">XSL Transformations (XSLT) Version 1.0 spec</a> does not have a method to turn self created elements into a node set. However, the <a href="http://msdn.microsoft.com/en-us/library/hz88kef0(VS.71).aspx" rel="nofollow noreferrer">MSXML parser</a> (3.0 or greater) does have an extension to provide that functionality. Also, there's an <a href="http://www.exslt.org/exsl/functions/node-set/index.html" rel="nofollow noreferrer">exslt extension</a> that I think some newer versions of Firefox support that will allow this dynamic swap of a variable to a node-set. But anyways, here's a stylesheet that works properly using the MSXML parser.</p> <pre><code><?xml version="1.0" encoding="utf-8"?> <xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="1.0" xmlns:msxsl="urn:schemas-microsoft-com:xslt" exclude-result-prefixes="msxsl"> <xsl:output method="xml"/> <xsl:template match="/"> <xsl:variable name="shows"> <xsl:apply-templates select="//data[@alias='Dates']"/> </xsl:variable> <shows> <xsl:apply-templates select="msxsl:node-set($shows)//show"> <xsl:sort select="substring(date, 7, 4)"/> <xsl:sort select="substring(date, 4, 2)"/> <xsl:sort select="substring(date, 1, 2)"/> </xsl:apply-templates> </shows> </xsl:template> <xsl:template match="show"> <xsl:copy-of select="."/> </xsl:template> <xsl:template match="data[@alias='Dates']"> <xsl:call-template name="eachDate"> <xsl:with-param name="node" select=".."/> <xsl:with-param name="dates" select="."/> </xsl:call-template> </xsl:template> <xsl:template name="eachDate"> <xsl:param name="node" select="."/> <xsl:param name="dates" select="''"/> <xsl:if test="string-length($dates)"> <show> <name><xsl:value-of select="$node/data[@alias='Show']/text()"/></name> <date><xsl:value-of select="substring-before($dates, ',')"/></date> </show> <xsl:call-template name="eachDate"> <xsl:with-param name="node" select="$node"/> <xsl:with-param name="dates" select="substring-after($dates, ',')"/> </xsl:call-template> </xsl:if> </xsl:template> </xsl:stylesheet> </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