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
Johnny BreenSubject: Formatting data after normalising the space?
Author: Johnny Breen
Date: 03 May 2005 10:01 AM
Hi I have an xslt query that I hoped someone could help me with.
Suppose I have the following xml data:
<?xml version="1.0"?>
<testthis>
<words name="alphabet">
<chars name="abc"/>
<chars name="def"/>
</words>
<words name="nums">
<chars name="123"/>
<chars name="456"/>
</words>
<words name="others">
<chars name="try"/>
<chars name="this"/>
</words>
</testthis>

If I use the following template on the data:

<xsl:template name="getArrays">
{<xsl:for-each word>
{
<xsl:for-each select="./chars">
<xsl:value-of select="./@name"/>,
<xsl:for-each>
},
</xsl:for-each>};
</xsl:template>

I would get an output something like this:
{
{abc,def,},
{123,456,},
{try,this,},};

So to strip out the trailing commas I did something like as follows:
<xsl:template name="getArrays">
{<xsl:variable name="itemListOutSide">
<xsl:for-each select="testthis/words">
{<xsl:variable name="itemListInside">
<xsl:for-each select="./chars">
<xsl:value-of select="./@name"/>,
</xsl:for-each>
</xsl:variable>
<xsl:value-of select="substring(normalize-space($itemListInside),0,
string-length(normalize-space($itemListInside))) "/>
},</xsl:for-each>
</xsl:variable>
<xsl:value-of select="substring(normalize-space($itemListOutside),0, string-length(normalize-space($itemListOutside)))"/>};
</xsl:template>


which gave me the correct output:
{{abc,def},{123,456},{try,this}};

but the normalize-space I needed to extract the trailing comma means the output is always stuck together on one line, what I need to do is ensure that each array is on a seperate line like this:
{{abc,def},
{123,456},
{try,this}};

Is there anyway to do this with the approach I am using here, or if not does anyone have any other suggestions as to how I should use a different approach to this problem.
It is necessary for me to output in this way as the arrays i'm working with are really large.
Any help would be appreciated.
Thanks,
Johnny

Postnext
(Deleted User) Subject: Formatting data after normalising the space?
Author: (Deleted User)
Date: 04 May 2005 08:44 AM
Hi Johnny,
my solution would be to place the comma before the value, with a test to avoid to print it for the first item

<xsl:for-each select="./chars">
<xsl:if test="position()!=1">,</xsl:if>
<xsl:value-of select="./@name"/>
</xsl:for-each>

Hope this helps,
Alberto

Posttop
Johnny BreenSubject: Formatting data after normalising the space?
Author: Johnny Breen
Date: 04 May 2005 09:23 AM
Thanks alot Alberto, that did the trick. It seems so simple now that you've shown me but I never would have thought of it.
Thanks again,
Johnny

 
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.