I'm using an Excel report from Analysis view to export the design steps to Excel:
SELECT DESSTEPS.DS_DESCRIPTION
FROM DESSTEPS
However, DESSTEPS.DS_DESCRIPTION field looks like this:
<html>
<body>
<div align="left"><font face="Arial"><span style="font-size:8pt">Call transaction </span></font><font
face="Arial" size="3"><span style="font-size:10pt">SU01</span></font></div>
</body>
</html>
and in Excel the corresponding cell looks like this:
<empty line>
<empty line>
<empty line>
<empty line>
Call transaction SU01
<empty line>
<empty line>
<empty line>
<empty line>
Is there a way to convert the HTML content to plain text (in the SQL query or in post-processing) in order to avoid blank lines in Excel?
Environment:
- ALM 11
- Oracle 10