时间戳

首页 > 解决方案 > 使用 XSLT 将 HTML 转换为 XML 以使用 SSIS 进行处理

html - 使用 XSLT 将 HTML 转换为 XML 以使用 SSIS 进行处理

问题描述

知道如何从此 html 页面获取 xslt。请注意，我只是想获得这些值。在此先感谢。

<
     <table style="font-size: 12px; border-color: #BFBFBF; border-style: solid; border-width: .05em; border-collapse: collapse; width: 1100px;">
        <tr bgcolor="#FFFFFF">
          <td style="padding-left: 3px; padding-right: 3px; border-collapse: collapse; border: 1px solid #BFBFBF;" nowrap="nowrap" rowspan="1" colspan="1"><B>Total Steps in Transaction</B></td>
          <td style="padding-left: 3px; padding-right: 3px; border-collapse: collapse; border: 1px solid #BFBFBF;" nowrap="nowrap" rowspan="1" colspan="1">4</td>
        </tr>
          <td style="padding-left: 3px; padding-right: 3px; border-collapse: collapse; border: 1px solid #BFBFBF;" nowrap="nowrap" rowspan="1" colspan="1"><B>Total Transaction Response Time</B></td>
          <td style="padding-left: 3px; padding-right: 3px; border-collapse: collapse; border: 1px solid #BFBFBF;" nowrap="nowrap" rowspan="1" colspan="1">2.2367 (seconds)</td>
        </tr>
        <tr bgcolor="#FFFFFF">
          <td style="padding-left: 3px; padding-right: 3px; border-collapse: collapse; border: 1px solid #BFBFBF;" nowrap="nowrap" rowspan="1" colspan="1"><B>Ave. Response Time Per Step</B></td>
          <td style="padding-left: 3px; padding-right: 3px; border-collapse: collapse; border: 1px solid #BFBFBF;" nowrap="nowrap" rowspan="1" colspan="1">0.5592 (seconds)</td>
        </tr>
        <tr bgcolor="#FFFFFF">
          <td style="padding-left: 3px; padding-right: 3px; border-collapse: collapse; border: 1px solid #BFBFBF;" nowrap="nowrap" rowspan="1" colspan="1"><B>Total Transaction Outage</B></td>
          <td style="padding-left: 3px; padding-right: 3px; border-collapse: collapse; border: 1px solid #BFBFBF;" nowrap="nowrap" rowspan="1" colspan="1">140 (minutes)</td>
        </tr>
        <tr bgcolor="#FFFFFF">
          <td style="padding-left: 3px; padding-right: 3px; border-collapse: collapse; border: 1px solid #BFBFBF;" nowrap="nowrap" rowspan="1" colspan="1"><B>Transaction Uptime Percentage</B></td>
          <td style="padding-left: 3px; padding-right: 3px; border-collapse: collapse; border: 1px solid #BFBFBF;" nowrap="nowrap" rowspan="1" colspan="1">99.69%</td>
        </tr>
        <tr bgcolor="#FFFFFF">
          <td style="padding-left: 3px; padding-right: 3px; border-collapse: collapse; border: 1px solid #BFBFBF;" nowrap="nowrap" rowspan="1" colspan="1"><B>Total Transaction Success Rate</B></td>
          <td style="padding-left: 3px; padding-right: 3px; border-collapse: collapse; border: 1px solid #BFBFBF;" nowrap="nowrap" rowspan="1" colspan="1">99.63%  (35474 Attempted, 35343 Successful)</td>
        </tr>
        <tr bgcolor="#FFFFFF">
          <td style="padding-left: 3px; padding-right: 3px; border-collapse: collapse; border: 1px solid #BFBFBF;" nowrap="nowrap" rowspan="1" colspan="1"><B># of Notifications</B></td>
          <td style="padding-left: 3px; padding-right: 3px; border-collapse: collapse; border: 1px solid #BFBFBF;" nowrap="nowrap" rowspan="1" colspan="1">13</td>
        </tr>
      </table>

标签： htmlxmlxslt

解决方案

指出您想要生成的 XML 会很有用（除非您只想从了解 SSIS 的人那里得到答案？）

如果您只想要一系列元素，例如

<item label="Total Steps in Transaction" value="4"/>

那么你只需要一个模板规则

<xsl:template match="tr">
  <item label="{td[1]}" value="{td[2]}"/>
</xsl:template>

推荐阅读