Load a HREF TAG from HTML Source

[GaryCollins]

Good morning everyone,

I have a problem with selecting a Href tag from an HTML source.
Unfortunately Qlik only returns me text fields with no link attached..

I'm using QlikView and just did the import from a web document and inserted the html.

This is the HTML I have:

<table id='table' cellspacing='0' cellpadding='2' class='tables' >
<tr class='row'>
<td>some text</td>
<td>some text</td>
<td>some text</td>
<td>some text</td>
<td>some text</td>
<td>some text</td>
<td><a href='https://url>some text</a></td>
</tr>
</table>

Unfortunately I can't change the formatting of the HTML page as it is from an external source.

How do I extract the href from the td? Thank you very much for your time and best regards

[Gysbert_Wassenaar · Accepted solution]

If you're using Qlikview then don't load the webdocument as html, but as delimited or fixed record. That way you get the raw html. Of course you then need to extract the bits you need, but at least all the bits will be there.