RE: [xsl] need help extracting data from xml with xmlss format

Subject: RE: [xsl] need help extracting data from xml with xmlss format
From: "M. David Peterson" <m.david@xxxxxxxxxx>
Date: Mon, 17 May 2004 20:30:19 -0600
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@xxxxxxxxxxxxxx]
> Sent: Monday, May 17, 2004 8:19 PM
> To: xsl-list@xxxxxxxxxxxxxxxxxxxxxx
> 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>

Current Thread