Subject: [xsl] Re: Sort XML based on Tokenized String of sort by field From: "Rebecca Sapir" <rsapir@xxxxxxxxxxxxxxxxxxxx> Date: Thu, 29 May 2008 11:53:28 -0400 |
Michael, >If you try something and it doesn't work, then by far the best way of >getting help is to tell us exactly what you did and exactly what happened >as a result; we'll then usually be able to tell you what you did wrong and >(provided we know what you were trying to achieve) how to put it right. >(I've no idea what you mean by "a variable tag", but if you showed us some >code, it would be self-evident). Sorry, I will clarify better. I created a stylesheet that will produce the stylesheet that I am looking for. It still needs enhancements for the data type but for now it is something like this- <?xml version="1.0"?> <xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="2.0" xmlns:saxon="http://saxon.sf.net/"> <xsl:variable name="PATH" select="REPORT/REPORT_FORMAT/PARENT_NODE"/> <xsl:variable name="ORDER_BY" select="REPORT/REPORT_FORMAT/ORDER_BY"/> <xsl:variable name="ORDER_BY_TOKEN" select="tokenize($ORDER_BY,'\s*,\s*')"/> <xsl:strip-space elements="*"/> <xsl:output indent="yes"/> <xsl:template match="/"> <xsl:element name="xsl:transform"> <xsl:attribute name="version" select="'2.0'"/> <xsl:element name="xsl:template"> <xsl:attribute name="match" select="concat('REPORT/',$PATH)"/> <xsl:element name="xsl:copy"> <xsl:element name="xsl:for-each"> <xsl:attribute name="select" select="'*'"/> <xsl:for-each select="$ORDER_BY_TOKEN"> <xsl:variable name="ORDER"> <xsl:choose> <xsl:when test="contains(normalize-space(.), 'DES')"> <xsl:text>descending</xsl:text> </xsl:when> <xsl:otherwise> <xsl:text>ascending</xsl:text> </xsl:otherwise> </xsl:choose> </xsl:variable> <xsl:variable name="VALUE"> <xsl:choose> <xsl:when test="contains(normalize-space(.), ' DES')"> <xsl:value-of select="substring-before(normalize-space(.), ' ')"/> </xsl:when> <xsl:otherwise> <xsl:value-of select="normalize-space(.)"/> </xsl:otherwise> </xsl:choose> </xsl:variable> <xsl:element name="xsl:sort"> <xsl:attribute name="select" select="$VALUE"/> <xsl:attribute name="order" select="$ORDER"/> </xsl:element> </xsl:for-each> <xsl:element name="xsl:copy-of"> <xsl:attribute name="select" select="'.'"/> </xsl:element> </xsl:element> </xsl:element> </xsl:element> <xsl:element name="xsl:template"> <xsl:attribute name="match" select="'*'"/> <xsl:element name="xsl:copy"> <xsl:element name="xsl:apply-templates"/> </xsl:element> </xsl:element> </xsl:element> </xsl:template> </xsl:stylesheet> In my java code, if I do two passes and transform the xml first with this stylesheet and then again with the stylesshet resulting from the first transformation, that works perfectly. In his post David mentioned being able to do this in one pass using the saxon:transform extension. I have not been able to figure out how to do this... He says " you can do that in one call to saxon, if you wish with the saxon-transform extension, which means that the generated stylesheet can just be ina variable and never actually serialised." I tried to create a variable to hold this stylesheet but when I output the variable - it is empty. Like I try <?xml version="1.0"?> <xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="2.0" xmlns:saxon="http://saxon.sf.net/"> <xsl:variable name="PATH" select="REPORT/REPORT_FORMAT/PARENT_NODE"/> <xsl:variable name="ORDER_BY" select="REPORT/REPORT_FORMAT/ORDER_BY"/> <xsl:variable name="ORDER_BY_TOKEN" select="tokenize($ORDER_BY,'\s*,\s*')"/> <xsl:strip-space elements="*"/> <xsl:output indent="yes"/> <xsl:template match="/"> <xsl:variable name="NEW_STYLESHEET" <xsl:element name="xsl:transform"> .... </xsl:element> </xsl:variable> <xsl:value-of select="$NEW_STYLESHEET"/> </xsl:template> </xsl:stylesheet> I want to somehow store the stylesheet and then call something like <xsl:copy-of select="saxon:transform($NEW_STYLESHEET,/)"/> if that would work... Thanks so much. - Rebecca Merlin Securities - #1 Prime Broker North America and #1 Prime Broker Single Strategy Funds - Global Custodian 2007 #1 Prime Broker for Hedge Funds under $1 Billion - Alpha Survey 2007 -------------------------------------------------------------------------- This message contains information from Merlin Securities, LLC, or from one of its affiliates, that may be confidential and privileged. If you are not an intended recipient, please refrain from any disclosure, copying, distribution or use of this information and note that such actions are prohibited. If you have received this transmission in error, please notify the sender immediately by telephone or by replying to this transmission. Merlin Securities, LLC is a registered broker-dealer. Services offered through Merlin Securities, LLC are not insured by the FDIC or any other Federal Government Agency, are not deposits of or guaranteed by Merlin Securities, LLC and may lose value. Nothing in this communication shall constitute a solicitation or recommendation to buy or sell a particular security.
Current Thread |
---|
|
<- Previous | Index | Next -> |
---|---|---|
Re: [xsl] Esoteric XSLT/FXSL questi, Dimitre Novatchev | Thread | RE: [xsl] Re: Sort XML based on Tok, Michael Kay |
Re: [xsl] Esoteric XSLT/FXSL questi, Dimitre Novatchev | Date | [xsl] using position() and last() w, Terry Ofner |
Month |