Want to Pull multiple following-sibling data to preceding-sibling element

sameer_kadam · May 9th, 2009, 04:35 AM

Hi,
I have one xml were same name of element having multiple following-sibling of preceding element. I am using xslt 1.0
XML

<book>
<sect3 id="a397038pkin" temp="ch0001s0219">
<title>Pharmacokinetics</title>
<para>For further information on pharmacology of antihistamines, <link linkend="a382920pcol">see the Antihistamines General Statement 4:00</link>.</para></sect3>
<sam>See <link linkend="a382920pkin">Pharmacokinetics in the associated General Statement for more information.</link></sam>
<sam>See <link linkend="a382920chem-stab">Chemistry and Stability in the associated General Statement for more information.</link></sam>
<sam>See <link linkend="a382929uses">Uses in the associated General Statement for more information.</link></sam>

</book>

XSLT
<xsl:template match="//sect3[following-sibling::sam]">
<sect3><xsl:copy-of select="@*" />
<xsl:apply-templates />
<xsl:apply-templates select="following-sibling::sam[1]"/>
</sect3>
</xsl:template>

OUT should render as below
<book>
<sect3 id="a397038pkin" temp="ch0001s0219">
<title>Pharmacokinetics</title>
<para>For further information on pharmacology of antihistamines, <link linkend="a382920pcol">see the Antihistamines General Statement 4:00</link>.</para>

<sam>See <link linkend="a382920pkin">Pharmacokinetics in the associated General Statement for more information.</link></sam>
<sam>See <link linkend="a382920chem-stab">Chemistry and Stability in the associated General Statement for more information.</link></sam>
<sam>See <link linkend="a382929uses">Uses in the associated General Statement for more information.</link></sam>
</sect3>
</book>

Please Help me

mhkay · May 9th, 2009, 05:22 AM

The only thing I can see wrong with your code is the [1] in <xsl:apply-templates select="following-sibling::sam[1]"/>. It looks as if you want to pull all the following siblings into the sect3 element, not only the first.

sameer_kadam · May 9th, 2009, 06:03 AM

Hi
Thanks for reply
If there are multiple <sect3> element then entire <sam> elements appears in every <sect3>
when i removed '[1]'
see below result
<book>
<sect3 id="a397038pkin" temp="ch0001s0219"><title>Pharmacokinetics</title><para>For further information on pharmacology of antihistamines, <link linkend="a382920pcol">see the Antihistamines General Statement 4:00</link>.</para>

<sam>See <link linkend="a382920pkin">Pharmacokinetics in the associated General Statement for more information.</link></sam>

<sam>See <link linkend="a382920chem-stab">Chemistry and Stability in the associated General Statement for more information.</link></sam>

<sam>See <link linkend="a382929uses">Uses in the associated General Statement for more information.</link></sam>

<sam>See <link linkend="a382920di">Drug Interactions in the associated General Statement for more information.</link></sam>

<sam>See <link linkend="a382920lab-test-interf">Lab Test Interferences in the associated General Statement for more information.</link></sam>

<sam>See <link linkend="a382920acute-tox">Acute Toxicity in the associated General Statement for more information.</link></sam>

<sam>See <link linkend="a382920pcol">Pharmacology in the associated General Statement for more information.</link></sam>

<sam>See <link linkend="a382920pkin">Pharmacokinetics in the associated General Statement for more information.</link></sam></sect3>

<sam>See <link linkend="a382920pkin">Pharmacokinetics in the associated General Statement for more information.</link></sam>

<sam>See <link linkend="a382920chem-stab">Chemistry and Stability in the associated General Statement for more information.</link></sam>

<sam>See <link linkend="a382929uses">Uses in the associated General Statement for more information.</link></sam><sect3 id="a397038pkin" temp="ch0001s0220"><title>DRUG NAME</title><para>For further information on Drug list. </para>

<sam>See <link linkend="a382920di">Drug Interactions in the associated General Statement for more information.</link></sam>

<sam>See <link linkend="a382920lab-test-interf">Lab Test Interferences in the associated General Statement for more information.</link></sam>

<sam>See <link linkend="a382920acute-tox">Acute Toxicity in the associated General Statement for more information.</link></sam>

<sam>See <link linkend="a382920pcol">Pharmacology in the associated General Statement for more information.</link></sam>

<sam>See <link linkend="a382920pkin">Pharmacokinetics in the associated General Statement for more information.</link></sam></sect3>

<sam>See <link linkend="a382920di">Drug Interactions in the associated General Statement for more information.</link></sam>

<sam>See <link linkend="a382920lab-test-interf">Lab Test Interferences in the associated General Statement for more information.</link></sam>

<sam>See <link linkend="a382920acute-tox">Acute Toxicity in the associated General Statement for more information.</link></sam>

<sam>See <link linkend="a382920pcol">Pharmacology in the associated General Statement for more information.</link></sam>

<sam>See <link linkend="a382920pkin">Pharmacokinetics in the associated General Statement for more information.</link></sam></book>

Martin Honnen · May 9th, 2009, 07:23 AM

Here is a sample stylesheet:

Code:

<xsl:stylesheet
  xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
  version="1.0">
  
  <xsl:output method="xml" indent="yes"/>
  <xsl:strip-space elements="*"/>
  
  <xsl:key name="k1" match="sam" use="generate-id(preceding-sibling::sect3[1])"/>
  
  <xsl:template match="book">
    <xsl:copy>
      <xsl:apply-templates select="sect3"/>
    </xsl:copy>
  </xsl:template>
  
  <xsl:template match="sect3">
    <xsl:copy>
      <xsl:apply-templates select="@* | node()"/>
      <xsl:apply-templates select="key('k1', generate-id())"/>
    </xsl:copy>
  </xsl:template>
  
  <xsl:template match="@* | node()">
    <xsl:copy>
      <xsl:apply-templates select="@* | node()"/>
    </xsl:copy>
  </xsl:template>

</xsl:stylesheet>

When applied against the following XML input sample

Code:

<book>
<sect3 id="a397038pkin" temp="ch0001s0219">
<title>Pharmacokinetics</title>
<para>For further information on pharmacology of antihistamines, <link linkend="a382920pcol">see the Antihistamines General Statement 4:00</link>.</para></sect3>
<sam>See <link linkend="a382920pkin">Pharmacokinetics in the associated General Statement for more information.</link></sam>
<sam>See <link linkend="a382920chem-stab">Chemistry and Stability in the associated General Statement for more information.</link></sam>
<sam>See <link linkend="a382929uses">Uses in the associated General Statement for more information.</link></sam>

<sect3 id="s2" temp="ch0001s0219">
<title>foo</title>
<para>For further information on pharmacology of antihistamines, <link linkend="a382920pcol">see the Antihistamines General Statement 4:00</link>.</para></sect3>
<sam>See <link linkend="a382920pkin">Pharmacokinetics in the associated General Statement for more information.</link></sam>
<sam>See <link linkend="a382920chem-stab">Chemistry and Stability in the associated General Statement for more information.</link></sam>
<sam>See <link linkend="a382929uses">Uses in the associated General Statement for more information.</link></sam>

 
</book>

it outputs

Code:

<?xml version="1.0" encoding="utf-8"?>
<book>
   <sect3 id="a397038pkin" temp="ch0001s0219">
      <title>Pharmacokinetics</title>
      <para>For further information on pharmacology of antihistamines, <link linkend="a382920pcol">see the Antihistamines General Statement 4:00</link>.</para>
      <sam>See <link linkend="a382920pkin">Pharmacokinetics in the associated General Statement for more information.</link>
      </sam>
      <sam>See <link linkend="a382920chem-stab">Chemistry and Stability in the associated General Statement for more information.</link>
      </sam>
      <sam>See <link linkend="a382929uses">Uses in the associated General Statement for more information.</link>
      </sam>
   </sect3>
   <sect3 id="s2" temp="ch0001s0219">
      <title>foo</title>
      <para>For further information on pharmacology of antihistamines, <link linkend="a382920pcol">see the Antihistamines General Statement 4:00</link>.</para>
      <sam>See <link linkend="a382920pkin">Pharmacokinetics in the associated General Statement for more information.</link>
      </sam>
      <sam>See <link linkend="a382920chem-stab">Chemistry and Stability in the associated General Statement for more information.</link>
      </sam>
      <sam>See <link linkend="a382929uses">Uses in the associated General Statement for more information.</link>
      </sam>
   </sect3>
</book>

If that does not help then you need to provide more details on the possible input and the result you want to create.

sameer_kadam · May 9th, 2009, 08:07 AM

Hi Martin,

It's work without any problem.
Thanku very much.