[XSL-LIST Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message]

"sum" of "substring"

Subject: "sum" of "substring"
From: Colin Simpson <Colin.Simpson@xxxxxxxxxxxxxxx>
Date: Thu, 23 Oct 2003 12:24:03 +0100
simpson sum
Hello

My problem:
I have a flat text file that has to be transformed into a predetermined XML
file.

Example:
TYPE1Field1AnotherField12.00YetAnotherField445.26FinalField
TYPE1ABCDEFABCDEFGHIJKL45.00ABCDEFGHIJKLMNO123.45ABCDEFGHIJ
TYPE2FieldAnother987.65Final

where the first 5 characters indicate which one of two record layouts it is.

I first do some rudimentary wrapping of the records, creating an
intermediary XML file that
I can then use XSLT to process:

<records>
<record>TYPE1Field1AnotherField12.0YetAnotherField445.26FinalField</record>
<record>TYPE1ABCDEFABCDEFGHIJKL45.0ABCDEFGHIJKLMNO123.45ABCDEFGHIJ</record>
<record>TYPE2FieldAnother987.65Final</record>
</records>


I can populate nodes in the final output XML file by extracting data via
"substring", such as 
<xsl:value-of select="substring(.,28,15)">

I need to total up certain numeric values within the record of a specific
layouts.
For example, I want to total up the values that occupy positions 24 thru 28
from all records of "TYPE1".
Is there any way of doing this?
I thought I should use "sum" but I can't figure out the syntax needed.

Kind regards
Colin Simpson

****************************************************************************

This email and any files transmitted with it are confidential and intended 
solely for the use of the individual or entity to whom they are addressed. 
If you have received this email in error please notify the system manager. 

****************************************************************************

 XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list


Current Thread

PURCHASE STYLUS STUDIO ONLINE TODAY!

Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced!

Buy Stylus Studio Now

Download The World's Best XML IDE!

Accelerate XML development with our award-winning XML IDE - Download a free trial today!

Don't miss another message! Subscribe to this list today.
Email
First Name
Last Name
Company
Subscribe in XML format
RSS 2.0
Atom 0.3
Site Map | Privacy Policy | Terms of Use | Trademarks
Free Stylus Studio XML Training:
W3C Member
Stylus Studio® and DataDirect XQuery ™are products from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2013 All Rights Reserved.