| Groups | Blog | Home |
dotnet xml : SelectNodes unique
[quoted text, click to view] Jason wrote: > to get the nodes of all unique values. for example there are 9 nodes, each > of these nodes have a value. 1 node has a value of "test1", another 3 nodes > have a value of "test2" and another 5 nodes have a value of "test3". so here > i have 9 nodes in total, but i know that 3 of them have the same value, and > the other 5 have the same value. i want just 3 nodes returned because there > are 3 distinct values. exactly the same as if i were to do a "SELECT > DISTINCT surname FROM users" in SQL that is possible with the filter [not(. = preceding-sibling::element-name)] e.g. with the XML being <root> <child>1</child> <child>2</child> <child>1</child> <child>3</child> <child>1</child> <child>2</child> </root> and the script (JScript) var xmlDocument = new ActiveXObject('Msxml2.DOMDocument.4.0'); xmlDocument.async = false; var loaded = xmlDocument.load('test20040310Result.xml'); xmlDocument.setProperty('SelectionLanguage', 'XPath'); var elements = xmlDocument.selectNodes( '//child[not(. = preceding-sibling::child)]'); for (var i = 0; i < elements.length; i++) { alert(elements[i].text); } three elements with text 1, 2, 3 are found. -- Martin Honnen http://JavaScript.FAQTs.com/
Hi
Would like to find out... to get the nodes of all unique values. for example there are 9 nodes, each of these nodes have a value. 1 node has a value of "test1", another 3 nodes have a value of "test2" and another 5 nodes have a value of "test3". so here i have 9 nodes in total, but i know that 3 of them have the same value, and the other 5 have the same value. i want just 3 nodes returned because there are 3 distinct values. exactly the same as if i were to do a "SELECT DISTINCT surname FROM users" in SQL Thanks jason
[quoted text, click to view] Jason wrote: > what if my xml doc looks like this > > <root> > <child1> > <ex1>1</ex1> > <ex2>3</ex2> > </child1> > <child2> > <ex1>2</ex1> > <ex2>9</ex2> > </child2> > <child3> > <ex1>2</ex1> > <ex2>9</ex2> > </child4> > <child5> > <ex1>5</ex1> > <ex2>3</ex2> > </child5> > <child6> > <ex1>5</ex1> > <ex2>3</ex2> > </child6> > </root> What do you want to extract? It is a bit odd that element names are numbered. -- Martin Honnen http://JavaScript.FAQTs.com/
HI
thanks for the feed back what if my xml doc looks like this <root> <child1> <ex1>1</ex1> <ex2>3</ex2> </child1> <child2> <ex1>2</ex1> <ex2>9</ex2> </child2> <child3> <ex1>2</ex1> <ex2>9</ex2> </child4> <child5> <ex1>5</ex1> <ex2>3</ex2> </child5> <child6> <ex1>5</ex1> <ex2>3</ex2> </child6> </root> Thanks again Jason [quoted text, click to view] "Martin Honnen" <Martin.Honnen@t-online.de> wrote in message news:Oxc3f5pBEHA.1140@TK2MSFTNGP10.phx.gbl... > > > Jason wrote: > > > to get the nodes of all unique values. for example there are 9 nodes, each > > of these nodes have a value. 1 node has a value of "test1", another 3 nodes > > have a value of "test2" and another 5 nodes have a value of "test3". so here > > i have 9 nodes in total, but i know that 3 of them have the same value, and > > the other 5 have the same value. i want just 3 nodes returned because there > > are 3 distinct values. exactly the same as if i were to do a "SELECT > > DISTINCT surname FROM users" in SQL > > that is possible with the filter > [not(. = preceding-sibling::element-name)] > e.g. with the XML being > > <root> > <child>1</child> > <child>2</child> > <child>1</child> > <child>3</child> > <child>1</child> > <child>2</child> > </root> > > and the script (JScript) > > var xmlDocument = new ActiveXObject('Msxml2.DOMDocument.4.0'); > xmlDocument.async = false; > var loaded = xmlDocument.load('test20040310Result.xml'); > xmlDocument.setProperty('SelectionLanguage', 'XPath'); > var elements = xmlDocument.selectNodes( > '//child[not(. = preceding-sibling::child)]'); > for (var i = 0; i < elements.length; i++) { > alert(elements[i].text); > } > > three elements with text 1, 2, 3 are found. > -- > > Martin Honnen > http://JavaScript.FAQTs.com/ >
nvrmind found it :-)
Thanks [quoted text, click to view] "Jason" <c_bananas@mighty.co.za> wrote in message news:ensVrMrBEHA.3132@TK2MSFTNGP11.phx.gbl... > HI > > thanks for the feed back > > what if my xml doc looks like this > > <root> > <child1> > <ex1>1</ex1> > <ex2>3</ex2> > </child1> > <child2> > <ex1>2</ex1> > <ex2>9</ex2> > </child2> > <child3> > <ex1>2</ex1> > <ex2>9</ex2> > </child4> > <child5> > <ex1>5</ex1> > <ex2>3</ex2> > </child5> > <child6> > <ex1>5</ex1> > <ex2>3</ex2> > </child6> > </root> > > Thanks again > Jason > "Martin Honnen" <Martin.Honnen@t-online.de> wrote in message > news:Oxc3f5pBEHA.1140@TK2MSFTNGP10.phx.gbl... > > > > > > Jason wrote: > > > > > to get the nodes of all unique values. for example there are 9 nodes, > each > > > of these nodes have a value. 1 node has a value of "test1", another 3 > nodes > > > have a value of "test2" and another 5 nodes have a value of "test3". so > here > > > i have 9 nodes in total, but i know that 3 of them have the same value, > and > > > the other 5 have the same value. i want just 3 nodes returned because > there > > > are 3 distinct values. exactly the same as if i were to do a "SELECT > > > DISTINCT surname FROM users" in SQL > > > > that is possible with the filter > > [not(. = preceding-sibling::element-name)] > > e.g. with the XML being > > > > <root> > > <child>1</child> > > <child>2</child> > > <child>1</child> > > <child>3</child> > > <child>1</child> > > <child>2</child> > > </root> > > > > and the script (JScript) > > > > var xmlDocument = new ActiveXObject('Msxml2.DOMDocument.4.0'); > > xmlDocument.async = false; > > var loaded = xmlDocument.load('test20040310Result.xml'); > > xmlDocument.setProperty('SelectionLanguage', 'XPath'); > > var elements = xmlDocument.selectNodes( > > '//child[not(. = preceding-sibling::child)]'); > > for (var i = 0; i < elements.length; i++) { > > alert(elements[i].text); > > } > > > > three elements with text 1, 2, 3 are found. > > -- > > > > Martin Honnen > > http://JavaScript.FAQTs.com/ > > > >
Read about "grouping methods" at:
http://www.topxml.com/code/default.asp?p=3&id=v20010129150851 and at: http://jenitennison.com/xslt/grouping/index.html Cheers, Dimitre Novatchev [XML MVP], FXSL developer, XML Insider, http://fxsl.sourceforge.net/ -- the home of FXSL Resume: http://fxsl.sf.net/DNovatchev/Resume/Res.html [quoted text, click to view] "Jason" <c_bananas@mighty.co.za> wrote in message news:exMdIypBEHA.3308@TK2MSFTNGP10.phx.gbl... > Hi > > Would like to find out... > to get the nodes of all unique values. for example there are 9 nodes, each > of these nodes have a value. 1 node has a value of "test1", another 3 nodes > have a value of "test2" and another 5 nodes have a value of "test3". so here > i have 9 nodes in total, but i know that 3 of them have the same value, and > the other 5 have the same value. i want just 3 nodes returned because there > are 3 distinct values. exactly the same as if i were to do a "SELECT > DISTINCT surname FROM users" in SQL > > Thanks > jason > >
jason,
could you show me how your xpath expression looks like ? thanks, [quoted text, click to view] "Jason" <c_bananas@mighty.co.za> wrote in message news:u6sSwRrBEHA.684@tk2msftngp13.phx.gbl... > nvrmind found it :-) > > Thanks > "Jason" <c_bananas@mighty.co.za> wrote in message > news:ensVrMrBEHA.3132@TK2MSFTNGP11.phx.gbl... > > HI > > > > thanks for the feed back > > > > what if my xml doc looks like this > > > > <root> > > <child1> > > <ex1>1</ex1> > > <ex2>3</ex2> > > </child1> > > <child2> > > <ex1>2</ex1> > > <ex2>9</ex2> > > </child2> > > <child3> > > <ex1>2</ex1> > > <ex2>9</ex2> > > </child4> > > <child5> > > <ex1>5</ex1> > > <ex2>3</ex2> > > </child5> > > <child6> > > <ex1>5</ex1> > > <ex2>3</ex2> > > </child6> > > </root> > > > > Thanks again > > Jason > > "Martin Honnen" <Martin.Honnen@t-online.de> wrote in message > > news:Oxc3f5pBEHA.1140@TK2MSFTNGP10.phx.gbl... > > > > > > > > > Jason wrote: > > > > > > > to get the nodes of all unique values. for example there are 9 nodes, > > each > > > > of these nodes have a value. 1 node has a value of "test1", another 3 > > nodes > > > > have a value of "test2" and another 5 nodes have a value of "test3". > so > > here > > > > i have 9 nodes in total, but i know that 3 of them have the same > value, > > and > > > > the other 5 have the same value. i want just 3 nodes returned because > > there > > > > are 3 distinct values. exactly the same as if i were to do a "SELECT > > > > DISTINCT surname FROM users" in SQL > > > > > > that is possible with the filter > > > [not(. = preceding-sibling::element-name)] > > > e.g. with the XML being > > > > > > <root> > > > <child>1</child> > > > <child>2</child> > > > <child>1</child> > > > <child>3</child> > > > <child>1</child> > > > <child>2</child> > > > </root> > > > > > > and the script (JScript) > > > > > > var xmlDocument = new ActiveXObject('Msxml2.DOMDocument.4.0'); > > > xmlDocument.async = false; > > > var loaded = xmlDocument.load('test20040310Result.xml'); > > > xmlDocument.setProperty('SelectionLanguage', 'XPath'); > > > var elements = xmlDocument.selectNodes( > > > '//child[not(. = preceding-sibling::child)]'); > > > for (var i = 0; i < elements.length; i++) { > > > alert(elements[i].text); > > > } > > > > > > three elements with text 1, 2, 3 are found. > > > -- > > > > > > Martin Honnen > > > http://JavaScript.FAQTs.com/ > > > > > > > > >
Don't see what you're looking for? Try a search.
|
June 2003
July 2003
August 2003
September 2003
October 2003
November 2003
December 2003
January 2004
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
| home · blog · groups | Questions? Comments? Contact the dn |