XML Editor
Sign up for a WebBoard account Sign Up Keyword Search Search More Options... Options
Chat Rooms Chat Help Help News News Log in to WebBoard Log in Not Logged in
Show tree view Topic
Topic Page 1 2 3 4 5 6 7 8 9 Go to previous topicPrev TopicGo to next topicNext Topic
Postnext
C. LopezSubject: Group Data
Author: C. Lopez
Date: 23 Nov 2004 04:45 PM
Hi! I have the following XML, And I need group this information by dates.
Example:
10.10.2004 00:00:00
3500/3600/3700
C-8001
VJOS
VJOS2
Con alimentación
Circulando

10.10.2004 01:00:00
S-8001 A/B
VJOS3
Cristalino

Somebody can Help Me...THANKS A LOT

-----------------------------
<Plant Descr="Planta XXX" name="XXX">
<Name type="STR" frequency="Static">
<VALUE Id="">XXX</VALUE>
</Name>
<GroupVariables Descr="" name="Comments">
<Comment Descr="" name="Comment">
<Equipment type="HSTRVEC" frequency="Free">
<Vector Date="10.10.2004 00:00:00">
<VALUE Id="1">3500/3600/3700</VALUE>
<VALUE Id="2">C-8001</VALUE>
</Vector>

<Vector Date="10.10.2004 01:00:00">
<VALUE Id="1">S-8001 A/B</VALUE>
</Vector>
</Equipment>
<User type="HSTRVEC" frequency="Free">
<Vector Date="10.10.2004 00:00:00">
<VALUE Id="1">VJOS</VALUE>
<VALUE Id="2">VJOS2</VALUE>
</Vector>
<Vector Date="10.10.2004 01:00:00">
<VALUE Id="1">VJOS3</VALUE>
</Vector>
</User>

<Free type="HSTRVEC" frequency="Free">
<Vector Date="10.10.2004 00:00:00">
<VALUE Id="1">Con alimentación </VALUE>
<VALUE Id="2">Circulando</VALUE>
</Vector>
<Vector Date="10.10.2004 01:00:00">
<VALUE Id="1">Cristalino</VALUE>
</Vector>
</Free>
</Comment>
</GroupVariables>
</Plant>

Postnext
Ivan PedruzziSubject: Group Data
Author: Ivan Pedruzzi
Date: 25 Nov 2004 01:05 AM
The following XSLT should help


<?xml version='1.0'?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:output method="text"/>

<xsl:template match="/">
<xsl:apply-templates select="//Vector">
<xsl:sort select="@Date"/>
</xsl:apply-templates>
</xsl:template>

<xsl:template match="Vector">
<xsl:value-of select="@Date"/><xsl:text>
</xsl:text>
<xsl:apply-templates select="VALUE"/>
<xsl:text>
</xsl:text>
</xsl:template>


<xsl:template match="VALUE">
<xsl:value-of select="."/><xsl:text>
</xsl:text>
</xsl:template>

</xsl:stylesheet>

Posttop
C. LopezSubject: Group Data
Author: C. Lopez
Date: 01 Dec 2004 01:35 PM
Thanks Ivan.
Your help was very Usefull.

 
Topic Page 1 2 3 4 5 6 7 8 9 Go to previous topicPrev TopicGo to next topicNext Topic
Download A Free Trial of Stylus Studio 6 XML Professional Edition Today! 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

Log In Options

Site Map | Privacy Policy | Terms of Use | Trademarks
Stylus Scoop XML Newsletter:
W3C Member
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.