Convert nested XML to flat one

dani1 · October 20th, 2008, 10:36 AM

Quote:

quote:Originally posted by mhkay
Please don't think in terms of "closing the tag". You're writing a tree of nodes, not a sequence of start and end tags.

OK, I'll do my best.

Quote:

quote:Originally posted by mhkay
The reason that there's a text node after the <Order> element is that you wrote it when you did

        <Order>
            <xsl:copy-of select="OrderNum"/>
            <xsl:copy-of select="OrderData1"/>
            <xsl:copy-of select="OrderData2"/>
            <xsl:copy-of select="OrderData3"/>
        </Order>
        <xsl:apply-templates/>

If you don't want it, why are you doing the apply-templates?

Michael Kay
http://www.saxonica.com/
Author, XSLT 2.0 and XPath 2.0 Programmer's Reference

But if I am not doing "apply-templates", I lost the next elements in tree.

For example if I remove "apply-templates" in "Orders", I'll have no elements "Line".

Martin Honnen · October 20th, 2008, 10:42 AM

Then use the xsl:apply-templates but add a template

Code:

<xsl:template match="text()"/>

to ensure that text nodes are not copied.

--
Martin Honnen
Microsoft MVP - XML

dani1 · October 20th, 2008, 11:05 AM

Quote:

quote:Originally posted by Martin Honnen
Then use the xsl:apply-templates but add a template

Code:

<xsl:template match="text()"/>

to ensure that text nodes are not copied.

--
Martin Honnen
Microsoft MVP - XML

I am sorry, I didn't understand how I can do that. May be you can give some example?

Martin Honnen · October 20th, 2008, 11:15 AM

I gave you the code already, add the template

Code:

<xsl:template match="text()"/>

to your stylesheet.

--
Martin Honnen
Microsoft MVP - XML

mrame · October 20th, 2008, 11:15 PM

Try this:

<xsl:template match="/">
        <root>
            <xsl:apply-templates/>
        </root>
    </xsl:template>

    <xsl:template match="Line">
        <xsl:copy-of select="."/>
    </xsl:template>

    <xsl:template match="Order">
        <Order>
            <xsl:copy-of select="OrderNum"/>
            <xsl:copy-of select="OrderData1"/>
            <xsl:copy-of select="OrderData2"/>
            <xsl:copy-of select="OrderData3"/>
        </Order>
        <xsl:apply-templates select="Line"/>
    </xsl:template>

    <xsl:template match="Header">
        <Header>
            <xsl:copy-of select="Hdr"/>
            <xsl:copy-of select="Data1"/>
            <xsl:copy-of select="Data2"/>
            <xsl:copy-of select="Data3"/>
        </Header>
        <xsl:apply-templates select="Order"/>
    </xsl:template>

Rummy

dani1 · October 21st, 2008, 02:20 AM

Quote:

quote:Originally posted by mrame
Try this:

<xsl:template match="/">
        <root>
            <xsl:apply-templates/>
        </root>
    </xsl:template>

    <xsl:template match="Line">
        <xsl:copy-of select="."/>
    </xsl:template>

    <xsl:template match="Order">
        <Order>
            <xsl:copy-of select="OrderNum"/>
            <xsl:copy-of select="OrderData1"/>
            <xsl:copy-of select="OrderData2"/>
            <xsl:copy-of select="OrderData3"/>
        </Order>
        <xsl:apply-templates select="Line"/>
    </xsl:template>

    <xsl:template match="Header">
        <Header>
            <xsl:copy-of select="Hdr"/>
            <xsl:copy-of select="Data1"/>
            <xsl:copy-of select="Data2"/>
            <xsl:copy-of select="Data3"/>
        </Header>
        <xsl:apply-templates select="Order"/>
    </xsl:template>

Rummy

Thank you, Rummy. That's it! :)

Now I have understood Martin Honnen's advise.