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
James DelaneySubject: substring-before and sums
Author: James Delaney
Date: 19 Jan 2010 04:39 PM
Originally Posted: 19 Jan 2010 04:37 PM
Hello all,

I have a simple problem that I haven't been able to figure out. I'm sure that I'm not applying something correct that you all may be easy to spot quickly:

I have a list of ages that have numerical and string data. I need to find the average age among the list. I can convert the data rows into numerical formats, but when I try to do calculations on it (like sum) it's returning an error (Input to sum() contains a value that is neither numeric, nor a duration).


XSL file:

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

<xsl:template match="/Students">

<xsl:value-of select="sum(number(Student/substring-before(Age, '(')))"/>

</xsl:template>
</xsl:stylesheet>


XML file:

<?xml version="1.0"?>
<Students>
<Student>
<Age>21 (5 months)</Age>
</Student>
<Student>
<Age>46 (5 months)</Age>
</Student>
<Student>
<Age>15 (0 months)</Age>
</Student>
</Students>

Expected Results:
82

Postnext
Tony LavinioSubject: substring-before and sums
Author: Tony Lavinio
Date: 25 Jan 2010 02:15 PM
Your expression is still including the space after the number - you only trimmed off the text from the '(' forward. Try removing that space. There is also a number() function that can coerce a string to a number.

Posttop
James DelaneySubject: substring-before and sums
Author: James Delaney
Date: 25 Jan 2010 02:53 PM
Hello Mr. Lavinio,

Thank you for the response. I have attempted to strip the space and the same issue with the sum/number is occurring. Also, without any modification of the string, a number() seems to always result in NaN.

May you have any other suggestions? Thank you again for your assistance.

 
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.