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
Conferences Close Tree View
+ Stylus Studio Feature Requests (1192)
+ Stylus Studio Technical Forum (14621)
+ Website Feedback (249)
- XSLT Help and Discussion (7625)
-> + Use of before and after string (3) Sticky Topic
-> - How do I substitute element ty... (1)
-> + How does one add working days ... (4)
-> - Help, I have existing XLT and... (1)
-> + Need help on XSLT issue - (2)
-> + EDI to XML Conversion (7)
-> - XML To JSON Conversion using X... (1)
-> + Formatting Paragraphs to same ... (2)
-> - Grouping of records (1)
-> + Problems with xsd 1.1 (4)
-> + XML to HL7 mapping (3)
-> + XSLT 3 and Iterate (2)
-> + XSL-FO to PDF preview (3)
-> + java.lang.RuntimeException: Er... (2)
-> + Create Acroforms with Stylus X... (2)
-> + How to change XSLT parameter s... (3)
-> + how to change format of the da... (2)
-> + Search "Next 8 Results " doesn... (2)
-> - Support for Git (1)
-> + newbee (8)
-- [1-20] [21-40] [41-60] Next
+ XQuery Help and Discussion (2017)
+ Stylus Studio FAQs (159)
+ Stylus Studio Code Samples & Utilities (364)
+ Stylus Studio Announcements (113)
Topic  
Posttop
Jeroen MulderSubject: HOWTO: follow every child of
Author: Jeroen Mulder
Date: 17 Aug 2005 03:39 PM
When I wanted to edit my previous post something went completly wrong ??

I Have the following xml file:
<root>
<scan>
<item1>Value 1</item1>
<item2>Value 2</item2>
<item3>Value 3</item3>
.
.
etc
<ffu_report>
<ffuitem1>ffuValue 1</ffuitem1>
<ffuitem2>ffuValue 2</ffuitem2>
<ffuitem3>ffuValue 3</ffuitem3>
.
.
etc
</ffu_report>
</scan>

<scan>
<item4>Value 1</item4>
<item5>Value 2</item5>
<item6>Value 3</item6>
.
.
etc
<ffu_report>
<ffuitem4>ffuValue 1</ffuitem4>
<ffuitem5>ffuValue 2</ffuitem5>
<ffuitem6>ffuValue 3</ffuitem6>
.
.
etc
</ffu_report>
</scan>

</root>

I want it to be an csv file with this layout.

all scandata in one row
scan1: item1, item2, item3, ffuitem1, ffuitem2, ffuitem3, ... etc
scan2: item1, item2, item3, ffuitem1, ffuitem2, ffuitem3, ... etc
.
.
etc

I was thinking of
<xsl:stylesheet version="1.0"
xmlns:xsl="<a href="http://www.w3.org/1999/XSL/Transform">">">http://www.w3.org/1999/XSL/Transform"></a>
<xsl:strip-space elements="*"/>

<xsl:output method="text"/>

<xsl:template match="scan">
<xsl:apply-templates/>
<xsl:text> &#xa;</xsl:text>
</xsl:template>

<xsl:template match="scan">
<xsl:text/> "<xsl:apply-templates/>"<xsl:text/>
<xsl:if test="following-sibling::scan"> ,</xsl:if>
</xsl:template>
</xsl:stylesheet>

BUT i thee followin-sibling part doesn't work....
I want to check if there are more fields in the scan part and if there are put a comma behind it

ANY ideas ????

regards,

Jeroen



   
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.