On 25/10/2007, Arthur Maloney <ArthurM(_at_)seipas(_dot_)com> wrote:
Depending on user choice. The Xml file contains 500-50,000 row elements
In the Xml file each row element contains between 2-15 agent elements
(there is always more than 1). The agent name should be the same in all agent
elements.
Example of Xml file
1. AppicantNumber is always unique for each row element
2. row 1 is not corrupt. All agent names the same
3. rows 2 and 3 are corrupt. Contain more than one agent name (row2
contains 4 names, row3 2 names).
<table>
...
<row>
<applicantNumber>56789</applicantNumber>
<agent>John1</agent>
<agent>John1</agent>
<agent>John1</agent>
<agent>John1</agent>
</row>
...
<row>
<applicantNumber>127789</applicantNumber>
<agent>John27</agent>
<agent>John1</agent>
<agent>Fred13</agent>
<agent>John27</agent>
<agent>John27</agent>
<agent>John27</agent>
<agent>Paul8</agent>
<agent>John27</agent>
</row>
...
<row>
<applicantNumber>16789345</applicantNumber>
<agent>Fred9</agent>
<agent>Fred9</agent>
<agent>Fred9</agent>
<agent>John1</agent>
<agent>Fred9</agent>
<agent>Fred9</agent>
<agent>Fred9</agent>
<agent>Fred9</agent>
<agent>Fred9</agent>
</row>
...
</table>
You haven't shown any XSLT or given a clue to what version you're
using (which is always a good idea)...
However in this case the solution is probably the same for both: to
check the applicant number is unique define a key and check that it
only ever contains a single item with that value eg:
<xsl:key name="appNum" match="applicantNumber" use="."/>
and then when matching <row>:
count(key('appNum', applicantNumber)) = 1
To check that all <agent>s contain the same value use:
agent != agent (one of the few times you want to use != ....!)
or maybe in 2.0:
count(distinct-values(agent) eq 1)
I hope this helps...
cheers
--
Andrew Welch
http://andrewjwelch.com
Kernow: http://kernowforsaxon.sf.net/
--~------------------------------------------------------------------
XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list
To unsubscribe, go to: http://lists.mulberrytech.com/xsl-list/
or e-mail: <mailto:xsl-list-unsubscribe(_at_)lists(_dot_)mulberrytech(_dot_)com>
--~--