Subject: Re: [xsl] filtering XML file using starts-with From: "Dan" <dan@xxxxxxxxxxxxxxx> Date: Thu, 18 Dec 2003 14:08:14 -0600 |
OK, I found the problem. I was actually looking at the wrong XML file so David's original answer was really all I needed. Thanx David ---------- Original Message ---------------------------------- From: "Dan" <dan@xxxxxxxxxxxxxxx> Reply-To: xsl-list@xxxxxxxxxxxxxxxxxxxxxx Date: Thu, 18 Dec 2003 10:42:14 -0600 >Thanx, but I don't think this is it. I checked the original XML file and the ! isn't there, it is an l as it should be. I did a copy paste and it must have been bungled somewhere along the line. The same XML file comes through fins if I don't try and filter it. weird though. Thanx. > >---------- Original Message ---------------------------------- >From: "Vasu Chakkera" <vasucv@xxxxxxxxxxx> >Reply-To: xsl-list@xxxxxxxxxxxxxxxxxxxxxx >Date: Thu, 18 Dec 2003 16:43:10 -0800 > >>Dan, >>I can see a problem in your XML.Its not a problem If its a typo . Your XML >>is not well formed because you have missspelt <value> as <va!lue> >>I am putting *** around where I think you have misspelt >><?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.92 >>5</value></NewTotalQuota><StrategicTotalQuota><value>60794058.915</value></S >>trategicTotalQuota><TotalTotalQuota><value>272530339.925</value></TotalTotal >>Quota><NewBucketQuota><value>0</value></NewBucketQuota><ResignTotalObjective >>><value>0</value></ResignTotalObjective><NewTotalObjective><value>181000000< >>/value></NewTotalObjective><NewBucketObjective><value>0</value></NewBucketOb >>jective><StrategicTotalObjective><value>18100000</value></StrategicTotalObje >>ctive><TotalTotalObjective><value>181000000</value></TotalTotalObjective><Pe >>rcentResignTotal><value>0</value></PercentResignTotal><PercentNewTotal><valu >>e>145.77</value></PercentNewTotal><PercentStrategicTotal><value>335.87</valu >>e></PercentStrategicTotal><PercentTotalTotal><value>150.56</value></PercentT >>otalTotal><PercentNewBucket> >>***<va! >>lue>0</value></PercentNewBucket><JobTitleCode><value>BSEM</value></JobTitleC >>ode><MarketSegmentCode><value>1</value></MarketSegmentCode><RowCounter><valu >>e>368</value></RowCounter></Summary> >> >>If it is an exact copy then it is wrong ....try to change and see. It should >>normally get you an exception if the XML is not wellformed >> >>Hope this helps >>Vasu >>----- Original Message ----- >>From: "Dan" <dan@xxxxxxxxxxxxxxx> >>To: <xsl-list@xxxxxxxxxxxxxxxxxxxxxx> >>Sent: Thursday, December 18, 2003 8:12 AM >>Subject: Re: [xsl] filtering XML file using starts-with >> >> >>> 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.92 >>5</value></NewTotalQuota><StrategicTotalQuota><value>60794058.915</value></S >>trategicTotalQuota><TotalTotalQuota><value>272530339.925</value></TotalTotal >>Quota><NewBucketQuota><value>0</value></NewBucketQuota><ResignTotalObjective >>><value>0</value></ResignTotalObjective><NewTotalObjective><value>181000000< >>/value></NewTotalObjective><NewBucketObjective><value>0</value></NewBucketOb >>jective><StrategicTotalObjective><value>18100000</value></StrategicTotalObje >>ctive><TotalTotalObjective><value>181000000</value></TotalTotalObjective><Pe >>rcentResignTotal><value>0</value></PercentResignTotal><PercentNewTotal><valu >>e>145.77</value></PercentNewTotal><PercentStrategicTotal><value>335.87</valu >>e></PercentStrategicTotal><PercentTotalTotal><value>150.56</value></PercentT >>otalTotal><PercentNewBucket><va! >>> >>lue>0</value></PercentNewBucket><JobTitleCode><value>BSEM</value></JobTitleC >>ode><MarketSegmentCode><value>1</value></MarketSegmentCode><RowCounter><valu >>e>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@xxxxxxxxx> >>> Reply-To: xsl-list@xxxxxxxxxxxxxxxxxxxxxx >>> 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 >>> >>> >> >> XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list >> >> > > XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list > > XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list
Current Thread |
---|
|
<- Previous | Index | Next -> |
---|---|---|
Re: [xsl] filtering XML file using , Dan | Thread | [xsl] One XML to MANY XSL's??, Jiles, Everett |
[xsl] format-number()-function ques, Jonny Pony | Date | Re: [xsl] One XML to MANY XSL's??, Wendell Piez |
Month |