SSDN - Split source xml based on input

XML Editor

Sign Up

Search

Options

Chat

Help

News

Log in

Not Logged in

Topic

Topic Page 1 2 3 4 5 6 7 8 9

Samz Sammy

Subject: Split source xml based on input
Author: Samz Sammy
Date: 30 Jul 2007 09:11 AM

Hi Friends

How do I go about splitting the XML based on ZDATE lets say the source xml is as below,

<Root>
<Values>
<Test>
<ZDATE>2007-05-21</ZDATE>
<ZNUMBER>123</ZNUMBER>
</Test>
<Test>
<ZDATE>2007-06-21</ZDATE>
<ZNUMBER>1234</ZNUMBER>
</Test>
<Test>
<ZDATE>2007-05-21</ZDATE>
<ZNUMBER>1234</ZNUMBER>
</Test>
<Test>
<ZDATE>2007-06-21</ZDATE>
<ZNUMBER>123</ZNUMBER>
</Test>
</Values>
</Root>

I want it to be converted to a target as this,

<Root>
<Values>
<Test>
<ZDATE>2007-05-21</ZDATE>
<ZNUMBER>123</ZNUMBER>
</Test>
<Test>
<ZDATE>2007-05-21</ZDATE>
<ZNUMBER>1234</ZNUMBER>
</Test>
</Values>
<Values>
<Test>
<ZDATE>2007-06-21</ZDATE>
<ZNUMBER>1234</ZNUMBER>
</Test>
<Test>
<ZDATE>2007-06-21</ZDATE>
<ZNUMBER>123</ZNUMBER>
</Test>
</Values>
</Root>

thanks
Sammy

Tony Lavinio

Subject: Split source xml based on input
Author: Tony Lavinio
Date: 30 Jul 2007 01:08 PM

See http://www.jenitennison.com/xslt/grouping

Samz Sammy

Subject: Split source xml based on input
Author: Samz Sammy
Date: 31 Jul 2007 05:42 AM

Thanks a lot. Got the solution to work now :):)

Topic Page 1 2 3 4 5 6 7 8 9

Powered by Stylus Studio, the world's leading XML IDE for XML, XSLT, XQuery, XML Schema, DTD, XPath, WSDL, XHTML, SQL/XML, and XML Mapping!

Go to Conference:

Log In Options Username: Password:

Site Map | Privacy Policy | Terms of Use | Trademarks

Stylus Studio® and DataDirect XQuery ™are from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2016 All Rights Reserved.