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 10 11 12 13 14 15 16 17 18 19 20 Go to previous topicPrev TopicGo to next topicNext Topic
Postnext
STEVEN IBBOTSONSubject: changing the look of xml
Author: STEVEN IBBOTSON
Date: 09 Nov 2005 09:17 AM
I am sorry to put up a request like this (as i guess it will be straight forward) but have not been working with xml/stylus studio for long, i have the following xml and would like to convert it to the xml at the bottom, if anyone can help i would be very grateful. Thanx in advance.

<fields>
<field name="SurnameNow">
<value>Geldof</value>
</field>
<field name="Forename">
<value>Bob</value>
</field>
<field name="CurrentResidence">
<value>United Kingdom</value>
</field>
</fields>

needs to look like

<SurnameNow>Geldof</SurnameNow>
<Forename>Bob</Forename>
<CurrentResidence>United Kingdom</CurrentResidence>

again thank you for any help you can provide.

Postnext
(Deleted User) Subject: changing the look of xml
Author: (Deleted User)
Date: 09 Nov 2005 01:38 PM
Stephen,
This should do the trick:
<?xml version="1.0"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:output indent="yes"/>
<xsl:template match="/">
<root>
<xsl:apply-templates select="//value"/>
</root>
</xsl:template>

<xsl:template match="value">
<xsl:element name="{../@name}">
<xsl:value-of select="text()"/>
</xsl:element>
</xsl:template>
</xsl:stylesheet>

Good luck,
Clyde Kessel

Postnext
STEVEN IBBOTSONSubject: changing the look of xml
Author: STEVEN IBBOTSON
Date: 10 Nov 2005 04:49 AM
That helped so thankyou, one other question, how do you skip values (off in the instance) so ie

<fields>
<field name="SurnameNow">
<value>Geldof</value>
</field>
<field name="Forename">
<value>Bob</value>
</field>
<field name="LivingAbroad">
<value>Off</value>
</field>
<field name="CurrentResidence">
<value>United Kingdom</value>
</field>
</fields>

needs to look like

<SurnameNow>Geldof</SurnameNow>
<Forename>Bob</Forename>
<CurrentResidence>United Kingdom</CurrentResidence>

Postnext
STEVEN IBBOTSONSubject: changing the look of xml
Author: STEVEN IBBOTSON
Date: 10 Nov 2005 05:46 AM
That helped so thankyou, one other question, how do you skip values (off in the instance) so ie

<fields>
<field name="SurnameNow">
<value>Geldof</value>
</field>
<field name="Forename">
<value>Bob</value>
</field>
<field name="LivingAbroad">
<value>Off</value>
</field>
<field name="CurrentResidence">
<value>United Kingdom</value>
</field>
</fields>

needs to look like

<SurnameNow>Geldof</SurnameNow>
<Forename>Bob</Forename>
<CurrentResidence>United Kingdom</CurrentResidence>

Postnext
(Deleted User) Subject: changing the look of xml
Author: (Deleted User)
Date: 10 Nov 2005 07:31 AM
Try this, Stephen

<xsl:template match="value">
<xsl:if test="text()!='Off'">
<xsl:element name="{../@name}">
<xsl:value-of select="text()"/>
</xsl:element>
</xsl:if>
</xsl:template>

Clyde

Postnext
STEVEN IBBOTSONSubject: changing the look of xml
Author: STEVEN IBBOTSON
Date: 10 Nov 2005 08:53 AM
Ok, this is what i have, i used code from your original post but i can not seem to get it working with the 'off' part.

As i said i am new so this might be going the long way around, any comments?


Unknowndata.xml
the raw data

Unknownconvertxfdf.xsl
the conversion xsl

Posttop
Ivan PedruzziSubject: changing the look of xml
Author: Ivan Pedruzzi
Date: 10 Nov 2005 10:57 AM
<?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:a="http://ns.adobe.com/xfdf/">
<xsl:output indent="yes"/>
<xsl:template match="/">
<Records>
<Form>
<xsl:for-each select="a:xfdf/a:fields/a:field[a:value != 'Off']">
<xsl:choose>
<xsl:when test="substring(./@name,1,8) = 'b12c96nf'">
<xsl:element name="{substring(./@name,9)}">
<xsl:value-of select="a:value"/>
</xsl:element>
</xsl:when>
<xsl:otherwise>
<xsl:element name="{./@name}">
<xsl:value-of select="a:value"/>
</xsl:element>
</xsl:otherwise>
</xsl:choose>
</xsl:for-each>
</Form>
</Records>
</xsl:template>
</xsl:stylesheet>



hope this helps
Ivan Pedruzzi
Stylus Studio Team

 
Topic Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 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-2011 All Rights Reserved.