XPath help

[JHD]

Hi,

I'm trying to use the XMLDataSource and DataList controls in Visual Web
Developer Express (VB.Net) to present the following rss file in a web
application. The problem lies in that I want to just select items (title,
description and link) that are in the 'april' category. Can anyone help me
with an XPath expression (or another way) of achieving this?

Thanks.


<rss version="2.0" xmlns:dc="http://purl.org/dc/elements/1.1/"
xmlns:xhtml="http://www.w3.org/1999/xhtml">
<channel>
<copyright>Copyright 2007</copyright>
<description>News Alerts</description>
<link></link>
<title></title>
<language>en</language>
<lastBuildDate>Thu, 12 Apr 2007 20:32:25 GMT</lastBuildDate>
<item>
<title>News title 1</title>
<description>News description 1</description>
<link>http://link1.com</link>
<pubDate>Weds, 11 Apr 2007 23:38:35 GMT</pubDate>
<category>Business</category>
<category>UK</category>
<category>April</category>
</item>
<item>
<title>News title 2</title>
<description>News description 2</description>
<link>http://link2.com</link>
<pubDate>Weds, 11 Apr 2007 23:38:35 GMT</pubDate>
<category>Sport</category>
<category>US</category>
<category>April</category>
</item>
<item>
<title>News title 3</title>
<description>News description 3</description>
<link>http://link3.com</link>
<pubDate>Fri, 23 Mar 2007 23:38:35 GMT</pubDate>
<category>Business</category>
<category>UK</category>
<category>March</category>
</item>
</channel>

</rss>

 

[pgfearo]

The following XPath expression returns the elements you need in a
nodeset result:

/rss/channel/item/pubDate[contains(.,"Apr")]/preceding-sibling::*

Cheers

Phil

http://pgfearo.googlepages.com/home