XML Editor
Sign up for a WebBoard account Sign Up Keyword Search Search More Options... Options
search
Chat Rooms Chat Help Help News News Log in to WebBoard Log in Not Logged in
Home » Boards » Stylus Studio Developer Network » Stylus Studio Technical Forum » changing the look of xml
Conferences Close Tree View
+ Stylus Studio Feature Requests (1192)
- Stylus Studio Technical Forum (14621)
-> - Stylus Studio - Registrar en o... (1)
-> + Stylus Studio - Registrar en o... (2)
-> + Can a pipeline send a file by ... (2)
-> + After Updateing WIN10 to WIN11... (12)
-> + Where do I add the custom java... (3)
-> + Where is the Diagram tab? (5)
-> + Applying XSLT to Word DOCX/XML (2)
-> - CSV conversion via ConvertToXM... (1)
-> + Text symbols in SS not same as... (4)
-> + Exposing xquery as webservice ... (6)
-> + Syntax Identifier (2)
-> + Saving a Converted XML as an X... (5)
-> + Output document cannot be pars... (4)
-> - Archiving output from conversi... (1)
-> + EDIFACT guideline from Stylus ... (3)
-> + CSV file putting all the data ... (5)
-> + Can't install Home version 64b... (5)
-> + presale - Can I covers this sc... (5)
-> + Problem with UNB (5)
-> + Splitting EDIFACT files pipeli... (4)
-- [1-20] [21-40] [41-60] Next
+ Website Feedback (249)
+ XSLT Help and Discussion (7625)
+ XQuery Help and Discussion (2017)
+ Stylus Studio FAQs (159)
+ Stylus Studio Code Samples & Utilities (364)
+ Stylus Studio Announcements (113)
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

   
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.