Extract XML using Dotnet

[csgraham74]

Hi Guys,

I want to populate a nodelist so that i can extract various details.
The xml document i have is similar to the one below. baiscally i want
to extract the first instance of <PP> including <PP1> <PP2> <PP3> then
separately extract the next instance of <PP> <PP1> <PP2> <PP3>. Does
anyone have any examples on how to do this ??? Im trying to create an
html table using these values but its a bit of a nightmare.

any help appreciated
<Text>
<Header>
</Header>
<Details>
<PP>LASU</PP>
<PP1>A</PP2>
<PP2>B</PP2>
<PP3>C</PP3>
<PP>REFUSE</PP>
<PP1>1</PP2>
<PP2>2</PP2>
<PP3>3</PP3>
</Details>
<Details>
<PP>test1</PP>
<PP1>A</PP2>
<PP2>B</PP2>
<PP3>C</PP3>
<PP>test2</PP>
<PP1>1</PP2>
<PP2>2</PP2>
<PP3>3</PP3>
</Details>
</Text>

[Martin Honnen]

csgraham74 wrote:

I want to populate a nodelist so that i can extract various details.
The xml document i have is similar to the one below. baiscally i want
to extract the first instance of <PP> including <PP1> <PP2> <PP3> then
separately extract the next instance of <PP> <PP1> <PP2> <PP3>. Does
anyone have any examples on how to do this ???
With .NET you can either use Xml(Text)Reader or an XPathDocument and
XPathNodeIterat or to do this, the following is a C# example using
XPathDocument and XPathNodeIterat or
XPathDocument document = new XPathDocument(@ "file.xml") ;
XPathNavigator navigator = document.Create Navigator();
XPathNodeIterat or nodeIterator =
navigator.Selec t("Text/Details/PP/text()");
while (nodeIterator.M oveNext()) {
Console.Write(" PP: {0}: ", nodeIterator.Cu rrent.Value);
XPathNodeIterat or nodeIterator2 = nodeIterator.Cu rrent.Select(
"../following-sibling::*[position() < 4]/text()");
while (nodeIterator2. MoveNext()) {
Console.Write(" {0}, ", nodeIterator2.C urrent.Value);
}
Console.WriteLi ne();
}
}
}
Note that you example is not even well-formed XML, you need to close the
<PP1> with </PP1>
<PP1>A</PP2>

^^^^^^

--

Martin Honnen --- MVP XML
http://JavaScript.FAQTs.com/