[XSL-LIST Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message]

RE: need help extracting data from xml with xmlss form

Subject: RE: 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
cell ss index
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:  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

PURCHASE STYLUS STUDIO ONLINE TODAY!

Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced!

Buy Stylus Studio Now

Download The World's Best XML IDE!

Accelerate XML development with our award-winning XML IDE - Download a free trial today!

Don't miss another message! Subscribe to this list today.
Email
First Name
Last Name
Company
Subscribe in XML format
RSS 2.0
Atom 0.3
Site Map | Privacy Policy | Terms of Use | Trademarks
Free Stylus Studio XML Training:
W3C Member
Stylus Studio® and DataDirect XQuery ™are products from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2013 All Rights Reserved.