troubleshooting Question

HTML to CSV using xslt

Avatar of Sridhar Lenkala
Sridhar Lenkala asked on
HTML* XSLTXML
4 Comments1 Solution373 ViewsLast Modified:
Hi all,

I need an xslt to convert HTML to CSV. I know there are other ways to convert but I have a process which only accept xslt to convert HTML to CSV.
I am attaching source HTML file and csv file i want, can some one please create xslt for me. Appreciate any help on this since this is an urgent requirement and i am new to xslt.

Essentially below file lines of the csv files are 1 on 1. and you can get them in the body part pasted below.

Total Transactions:,245
Successful Transactions:,243
Failed Transactions:,2
Duplicate Transactions:,0
Unprocessed Transactions:,0
Transaction,Error Message,Details

 <body>
        <div class="container-fluid">
          <h4>Upload Summary</h4>
          <div class="row">
            <div class="col-md-4">
              <table class="table table-bordered table-striped table-condensed">
                <tr>
                  <td>
                    <b>Total Transactions:</b>
                  </td>
                  <td align="right">245</td>
                </tr>
                <tr>
                  <td colspan="2">
                    <hr/>
                  </td>
                </tr>
                <tr>
                  <td align="right">
                    <b>Successful Transactions:</b>
                  </td>
                  <td align="right">243</td>
                </tr>
                <tr>
                  <td align="right">
                    <b>Failed Transactions:</b>
                  </td>
                  <td align="right">2</td>
                </tr>
                <tr>
                  <td align="right">
                    <b>Duplicate Transactions:</b>
                  </td>
                  <td align="right">0</td>
                </tr>
                <tr>
                  <td align="right">
                    <b>Unprocessed Transactions:</b>
                  </td>
                  <td align="right">0</td>
                </tr>
              </table>
            </div>
          </div>
          <hr/>
          <h5>Error Summary</h5>
          <div class="row">
            <div class="col-md-12">
              <table class="table table-bordered table-striped table-condensed tablesorter">
                    <thead>
                     <tr>
                       <th class="col-md-1" align="center">Transaction</th>
                       <th class="col-md-10">Error Message</th>
                       <th class="col-md-1" align="center">Details</th>
                     </tr>
                  </thead>
                  <tbody>
FailureReport--19-.html
convertcsv.csv
ASKER CERTIFIED SOLUTION
Gertone (Geert Bormans)
Information Architect

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Top Expert 2006

The Distinguished Expert awards are presented to the top veteran and rookie experts to earn the most points in the top 50 topics.

Join our community to see this answer!
Unlock 1 Answer and 4 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 4 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros