Hi Jeremy,
Please help clarify your problem so that we can better help you.
- When you say wildcard for ss:Index="*" do you mean that you
want your xpath statement to match every value of ss:Index?\
- When you say "everything in between" do you mean "Cell" and
"Data" and the associated attributes and values?
If not, please clarify what criteria will cause your rows not to match
and just what data it is you are looking for. Please keep your sample
data as short as possible while still showcasing just exactly what it is
you are having problems with. With this information we will be able to
help you get to the root of your problem much easier.
Best regards,
<M:D/>
-----Original Message-----
From: Jeremy Allen [mailto:jallen(_at_)sirius-its(_dot_)net]
Sent: Monday, May 17, 2004 8:19 PM
To: xsl-list(_at_)lists(_dot_)mulberrytech(_dot_)com
Subject: [xsl] need help extracting data from xml with xmlss format
I have an xml file that uses xmlss. I can extract the information with
no
problem, however is there a wildcard in an xpath expression I can use
so
that I don't have to type in the specific index for every line. I need
to
be
able to pull the data for each "Row" node, IE..<Row ss:Index=*>, and
everything in between. Help!! Thanks in advance
Example:
- <Row ss:Index="7">
- <Cell ss:Index="1">
<Data ss:Type="String">NET PAY</Data>
</Cell>
- <Cell ss:Index="2">
<Data ss:Type="String">NET PAY</Data>
</Cell>
- <Cell ss:Index="3">
<Data ss:Type="String">1000</Data>
</Cell>
- <Cell ss:Index="5" ss:StyleID="s22">
<Data ss:Type="Number">15,392.70</Data>
</Cell>
- <Cell ss:Index="6">
<Data ss:Type="Number">0000</Data>
</Cell>
- <Cell ss:Index="7">
<Data ss:Type="Number">000000</Data>
</Cell>
</Row>
- <Row ss:Index="8">
- <Cell ss:Index="1">
<Data ss:Type="String">FEDERAL W/H</Data>
</Cell>
- <Cell ss:Index="2">
<Data ss:Type="String">FEDERAL W/H</Data>
</Cell>
- <Cell ss:Index="3">
<Data ss:Type="String">1200</Data>
</Cell>
- <Cell ss:Index="5" ss:StyleID="s22">
<Data ss:Type="Number">1,764.16</Data>
</Cell>
- <Cell ss:Index="6">
<Data ss:Type="Number">0000</Data>
</Cell>
- <Cell ss:Index="7">
<Data ss:Type="Number">000000</Data>
</Cell>
</Row>
- <Row ss:Index="9">
- <Cell ss:Index="1">
<Data ss:Type="String">EE S.S. PAYABLE</Data>
</Cell>
- <Cell ss:Index="2">
<Data ss:Type="String">EE S.S. PAYABLE</Data>
</Cell>
- <Cell ss:Index="3">
<Data ss:Type="String">1200</Data>
</Cell>
- <Cell ss:Index="5" ss:StyleID="s22">
<Data ss:Type="Number">1,665.69</Data>
</Cell>
- <Cell ss:Index="6">
<Data ss:Type="Number">0000</Data>
</Cell>
- <Cell ss:Index="7">
<Data ss:Type="Number">000000</Data>
</Cell>
</Row>
--+------------------------------------------------------------------
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>
--+--