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 |
---|
|
<- Previous | Index | Next -> |
---|---|---|
[xsl] need help extracting data fro, Jeremy Allen | Thread | [xsl] Problem namespaces Xalan Java, poppe chris |
[xsl] need help extracting data fro, Jeremy Allen | Date | RE: [xsl] XSLT for toplevel element, Josh Canfield |
Month |