Inserting one element into another

srini · January 20th, 2004, 05:05 AM

Hi All,
I have to write an XSLT.

I have a xml element like below

<MD_Body>
    <SHRow rowsep="1"></SHRow>

    <MD_Row1>
        <MsgSN>Type</MsgSN>
        <MsgNo>8</MsgNo>
    </MD_Row1>
    <MD_Row1>
        <MsgSN>Res</MsgSN>
        <MsgNo>8</MsgNo>
    </MD_Row1>

    <SHRow rowsep="1">

    </SHRow>
    <MD_Row1>
        <MsgSN Id="CJAJHIGH">Length</MsgSN>
        <MsgNo>1</MsgNo>
    </MD_Row1>

    <SHRow rowsep="1"></SHRow>

    <MD_Row1>
        <MsgSN>Res</MsgSN>
        <MsgNo>8</MsgNo>
    </MD_Row1>

    <MD_Row1>
        <MsgSN Id="CJAHABGI">ALPHA</MsgSN>
        <MsgNo>4</MsgNo>
    </MD_Row1>
    <MD_Row1>
        <MsgSN>BETA</MsgSN>
        <MsgNo>4</MsgNo>
    </MD_Row1>
</MD_Body>

This I want to convert it as below

<MD_Body>
    <SHRow rowsep="1">

        <MD_Row1>
            <MsgSN>Type</MsgSN>
            <MsgNo>8</MsgNo>
        </MD_Row1>
        <MD_Row1>
            <MsgSN>Res</MsgSN>
            <MsgNo>8</MsgNo>
        </MD_Row1>

    </SHRow>

    <SHRow rowsep="1">

        <MD_Row1>
            <MsgSN Id="CJAJHIGH">Length</MsgSN>
            <MsgNo>1</MsgNo>
        </MD_Row1>
    </SHRow>

    <SHRow rowsep="1">
        <MD_Row1>
            <MsgSN>Res</MsgSN>
            <MsgNo>8</MsgNo>
        </MD_Row1>

        <MD_Row1>
            <MsgSN Id="CJAHABGI">ALPHA</MsgSN>
            <MsgNo>4</MsgNo>
        </MD_Row1>
        <MD_Row1>
            <MsgSN>BETA</MsgSN>
            <MsgNo>4</MsgNo>
        </MD_Row1>
    </SHRow>
</MD_Body>

please help me.
srini.

srini

joefawcett · January 20th, 2004, 01:37 PM

I had to get help on this one :)

Basically you need to select all the SHRow elements and then process all the MD_Row1 following sibling elements that have their immediately previous SHRow equal to the current SHRow:

Code:

<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">

  <xsl:template match="MD_Body">
    <xsl:copy>
      <xsl:apply-templates select="SHRow"/>
    </xsl:copy>
  </xsl:template>

  <xsl:template match="SHRow">
    <xsl:copy>
      <xsl:apply-templates select="following-sibling::MD_Row1[generate-id(preceding-sibling::SHRow[1]) = generate-id(current())]"/>
    </xsl:copy>
  </xsl:template>

  <xsl:template match="MD_Row1">
    <xsl:copy>
      <xsl:apply-templates select="@* | node()"/>
    </xsl:copy>    
  </xsl:template>

  <xsl:template match="@* | node()">
    <xsl:copy>
      <xsl:apply-templates select="@* | node()"/>
    </xsl:copy>    
  </xsl:template>

</xsl:stylesheet>

You can also do it by treating it as a value based grouping problem. Examples of this are at:

http://www.jenitennison.com/xslt/grouping/index.html
Joe (MVP -xml)

srini · January 21st, 2004, 01:08 AM

Thank you very much.
srini.

srini

joefawcett · January 21st, 2004, 08:09 AM

As this is a recursive process you may find with large files that it takes too long. If this is the case then a non-recursive process is discussed here: http://aspn.activestate.com/ASPN/Mai...l-list/1913969
It is obviously more complicated and will need tailoring to your structure.

Joe (MVP - xml)