how to correct use element xsl:key?

rympet · February 23rd, 2011, 03:03 AM

Code:

Hi all,

I should to generate this xml file: 
<document>
    <line id="0">
        <field id="0"><![CDATA[MAR5555]]></field>
        <field id="1"><![CDATA[something]]></field>
        <field id="2"><![CDATA[something]]></field>
        <field id="3"><![CDATA[something12123]]></field>
        <field id="4"/>
        <field id="5"/>
        <field id="6"/>
        <field id="7"/>
        <field id="8"/>
        <field id="9"/>
        <field id="10"/>
        <field id="11"/>
        <field id="12"/>
        <field id="13"/>
        <field id="14"/>
        <field id="15"/>
        <field id="16"/>
        <field id="17"><![CDATA[0072972+1313113123123]]></field>
        <field id="18"><![CDATA[5353]]></field>
        <field id="19"><![CDATA[444432323]]></field>
        <field id="20"/>
        <field id="21"/>
    </line>
    <line id="1">
        <field id="0"><![CDATA[MAR6435]]></field>
        <field id="1"><![CDATA[car123]]></field>
        <field id="2"><![CDATA[sds]]></field>
        <field id="3"><![CDATA[fest]]></field>
        <field id="4"/>
        <field id="5"/>
        <field id="6"/>
        <field id="7"/>
        <field id="8"/>
        <field id="9"/>
        <field id="10"/>
        <field id="11"/>
        <field id="12"/>
        <field id="13"/>
        <field id="14"/>
        <field id="15"><![CDATA[0000062+0dadasd]]></field>
        <field id="16"><![CDATA[032]]></field>
        <field id="17"><![CDATA[23242442]]></field>
        <field id="18"/>
        <field id="19"><![CDATA[000000]]></field>
        <field id="20"/>
        <field id="21"/>
    </line>
    <line id="2">
        <field id="0"><![CDATA[MAR6435]]></field>
        <field id="1"><![CDATA[sss]]></field>
        <field id="2"><![CDATA[Something111]]></field>
        <field id="3"><![CDATA[something111]]></field>
        <field id="4"/>
        <field id="5"/>
        <field id="6"/>
        <field id="7"/>
        <field id="8"/>
        <field id="9"/>
        <field id="10"/>
        <field id="11"/>
        <field id="12"/>
        <field id="13"/>
        <field id="14"/>
        <field id="15"><![CDATA[0000062+0sdsd]]></field>
        <field id="16"><![CDATA[022]]></field>
        <field id="17"><![CDATA[23444444]]></field>
        <field id="18"/>
        <field id="19"><![CDATA[000000]]></field>
        <field id="20"/>
        <field id="21"/>
    </line>
</document>

My programs looks:

Code:

<xsl:stylesheet version="1.0"xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:output method="xml" indent="yes" omit-xml-declaration="yes"/>
<xsl:key name="kLine" match="line" use="substring-before(field[contains(., '+')],'+')"/>
    <xsl:template match="/*">
        <document>
         <xsl:apply-templates select="line[contains(field[@id='0'], 'MAR')][count( . | key('kLine',substring-before(field[contains(., '+')],'+'))[1]) = 1]"/>
        </document>
    </xsl:template>
    <xsl:template match="line">
      <type-MAR>
       <document>
        <xsl:value-of select="substring-before(field[contains(., '+')],'+')"/> 
       </document>
        <!--     For each document-->
        <line>
         <LineNumber>
          <xsl:value-of select="position()"/>
         </LineNumber>
         <LineItem>
           <xsl:value-of select="'should be fielled number of after two fields which contain symbol + '"/>
         </LineItem>
        </line>
        <!-- For each document-->
       </type-MAR>
        </xsl:template>
</xsl:stylesheet>

first off all it appliess template lines wich field id 0 contains MAR and symbol '+'. Then select all numbers before symbol '+'.

I'm stuck, taking LineItem number after field id which contains symbol '+'. for example if I know that 'field id = 17' has + symbol, then after two rows I will have LineItem and do calculating I mean if 'field id = 17' when 'field id = 17+2', if 'field id = 16' then 'field id = 18' and so on. but now when field with symbol '+' are not defining, I can't to do it. Also if I use 'key', i want to ask how to use correct cycle "for each", to calculate number of lines. Result should be:

Code:

<document>
    <type-MAR>
        <document>0072972</document>
        <line>
            <LineNumber>1</LineNumber>
            <LineItem>444432323</LineItem>
        </line>
    </type-MAR>
    <type-MAR>
        <document>0000062</document>
        <line>
            <LineNumber>1</LineNumber>
            <LineItem>23242442</LineItem>
            <LineNumber>2</LineNumber>
            <LineItem>23444444</LineItem>
        </line>
    </type-MAR>
</document>

Please help

samjudson · February 23rd, 2011, 04:40 AM

Something like "field[contains(., '+')]/following-sibling::field[2]" would select the field element 2 after the first field element with a + in its text.

I hope that answers the question. If not then you'll need to explain it clearer.

rympet · February 23rd, 2011, 05:29 AM

yes it is works. But how to adapt it for cycle. I mean then I use apply templates I calculate documents. In this example, I have 3 lines(line id), in this lines I have two document, one document has two LineItem. and I'm stuck on for each:

Quote:

<xsl:for-each select="???">

, that this will take for one document some LineItem

Quote:

field[contains(., '+')]/following-sibling::field[2]

.

mhkay · February 23rd, 2011, 05:41 AM

Just to let you know: I am reading your questions, but not answering because I do not understand them. Also, it seems that whenever you get an answer, you change the question, which can be very frustrating for anyone trying to help you. But when you write non-sentences like "But how to adapt it for cycle. I mean then I use apply templates I calculate documents.", I'm afraid I have simply no idea what you are asking.

rympet · February 23rd, 2011, 05:54 AM

I'm not change the question. The question how to get LineItem in differents document(for it i try to use cycle "for each", but now progmram it show only one result instead of two), which can have two or more lines Item. Also I show how looks xml, and how should to show result.

rympet · February 23rd, 2011, 09:04 AM

I solve it byself.

<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:output method="xml" indent="yes" omit-xml-declaration="yes"/>
<xsl:key name="kLine" match="line" use="substring-before(field[contains(., '+')],'+')"/>
<xsl:template match="/*">
<document>
<xsl:apply-templates select="line[contains(field[@id='0'], 'MAR')][count( . | key('kLine',substring-before(field[contains(., '+')],'+'))[1]) = 1]"/>
</document>
</xsl:template>
<xsl:template match="line">
<xsl:variable name="doc_code" select="substring-before(field[contains(., '+')],'+')"/>
<type-MAR>
<document>
<xsl:value-of select="substring-before(field[contains(., '+')],'+')"/>
</document>
<xsl:for-each select="//line[substring-before(field[contains(., '+')],'+')=$doc_code]">
<line>
<LineNumber>
<xsl:value-of select="position()"/>
</LineNumber>
<LineItem>
<xsl:value-of select="field[contains(., '+')]/following-sibling::field[2]"/>
</LineItem>
</line>
</xsl:for-each>
</type-MAR>
</xsl:template>
</xsl:stylesheet>

samjudson · February 23rd, 2011, 09:16 AM

Selecting all the 'line' elements that match the current line element is pretty easy - you'd just do something like this:

[code]
<xsl:for-each select="../line[field[@id='0' and . = current()/field[@id='0']]]">
<LineNumber><xsl:value-of select-"position()"/></LineNumber>
<LineItem><xsl:value-of select="field[contains(., '+')]/following-sibling::field[2]"/></LineItem>
</xsl:for-each>