Breaking an XML file into smaller XML files...

[paulb]

Hello all!
I have an XML file I have imported from MS Excel. I now need to break the document up into smaller XML documents, each uniquely named using an element value. My guess is I will have to dust off the XSLT textbooks, but I was hoping there was a quicker way to do this in Oxygen than me having to write the transformation. Suggestions for other ways to go about this problem are welcome!

The parent XML file...

Code: Select all

    <row>

        <dc:title>paul</dc:title>

        <dc:creator>mom</dc:creator>

        <dc:identifier>1977</dc:identifier>

    </row>

    <row>

        <dc:title>brad</dc:title>

        <dc:creator>dad</dc:creator>

        <dc:identifier>1978</dc:identifier>

    </row>

    <row>

        <dc:title>melissa</dc:title>

        <dc:creator>mom and dad</dc:creator>

        <dc:identifier>1979</dc:identifier>

    </row>

Needs to be broken up into 3 separate XML files...
This file should be named 1977.xml

Code: Select all

    <row>

        <dc:title>paul</dc:title>

        <dc:creator>mom</dc:creator>

        <dc:identifier>1977</dc:identifier>

    </row>

And this file should be named 1978.xml

Code: Select all

    <row>

        <dc:title>brad</dc:title>

        <dc:creator>dad</dc:creator>

        <dc:identifier>1978</dc:identifier>

    </row>

Cheers, Paul

[adrian]

Hello,

Here's no quicker way than a stylesheet.

Try with this one:

Code: Select all

<?xml version="1.0" encoding="UTF-8"?>

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

    xmlns:dc="myns">

    <xsl:template match="/">

        <xsl:for-each-group select="//row" group-by="dc:identifier/text()">

            <xsl:result-document href="{concat(current-grouping-key(), '.xml')}" method="xml">

                <xsl:element name="root">

                    <xsl:copy-of select="current-group()"/>

                </xsl:element>

            </xsl:result-document>

        </xsl:for-each-group>

    </xsl:template>

</xsl:stylesheet>

You may need to make some small adjustments to the root element name and the namespace associated with the dc prefix.

Regards,
Adrian