xsl-list
[Top] [All Lists]

Re: filtering XML file using starts-with

2003-12-18 09:12:22
You are exactly right about the pretty print and I suspect right about the 
rest.  However, I am still getting no results back.  Here is the exact XML 
copied from notepad this time:

<?xml version="1.0"?>
<Sales><Summary><Employee><value>Gazlay-Martin, 
Janet</value></Employee><Module><value>101</value></Module><ResignTotalQuota><value>8686333</value></ResignTotalQuota><NewTotalQuota><value>263844006.925</value></NewTotalQuota><StrategicTotalQuota><value>60794058.915</value></StrategicTotalQuota><TotalTotalQuota><value>272530339.925</value></TotalTotalQuota><NewBucketQuota><value>0</value></NewBucketQuota><ResignTotalObjective><value>0</value></ResignTotalObjective><NewTotalObjective><value>181000000</value></NewTotalObjective><NewBucketObjective><value>0</value></NewBucketObjective><StrategicTotalObjective><value>18100000</value></StrategicTotalObjective><TotalTotalObjective><value>181000000</value></TotalTotalObjective><PercentResignTotal><value>0</value></PercentResignTotal><PercentNewTotal><value>145.77</value></PercentNewTotal><PercentStrategicTotal><value>335.87</value></PercentStrat
 
egicTotal><PercentTotalTotal><value>150.56</value></PercentTotalTotal><PercentNewBucket><va!
lue>0</value></PercentNewBucket><JobTitleCode><value>BSEM</value></JobTitleCode><MarketSegmentCode><value>1</value></MarketSegmentCode><RowCounter><value>368</value></RowCounter></Summary>

And here is the for-each line I am using

<xsl:for-each select="Sales/Summary[starts-with(Module/value,'10')]">

Thanx for your help, do you ahve a book recomendation BTW?

---------- Original Message ----------------------------------
From: David Carlisle <davidc(_at_)nag(_dot_)co(_dot_)uk>
Reply-To: xsl-list(_at_)lists(_dot_)mulberrytech(_dot_)com
Date:  Thu, 18 Dec 2003 15:44:39 GMT


- <Module>
 <value>101</value> 
 </Module>

You posted an IE6 "pretty print" view of the file (I would guess)
not your real input.

which means I'm still lacking information, however if the source
does really look like that (without the "-") then the string value of
Module is
newline space space 1 0 1 newline space space
so doesn't start with "10"

You probably want (starts-with(Module/value,'10')

-- 
http://www.dcarlisle.demon.co.uk/matthew

________________________________________________________________________
This e-mail has been scanned for all viruses by Star Internet. The
service is powered by MessageLabs. For more information on a proactive
anti-virus service working around the clock, around the globe, visit:
http://www.star.net.uk
________________________________________________________________________

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



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