Forum Discussion
gvg
3 years agoPost Prodigy
How to parse <td> tags with HTML.Table ?
Hello, I am trying to figure out how HTML.Table works. Microsoft description of this function is very basic. Let's say I have a simple HTML code "<td> 100.67</td>" from which I want to extract the v...
- 3 years ago
Hi gvg
It looks like the issue might be with the way the HTML code is formatted. The Html.Table function expects the input HTML code to be in a specific format, with a table structure containing rows and columns. The code you provided is just a single cell in a table, without any surrounding table structure.
Note that in this example, the HTML code has a table structure, with a single row and a single cell containing the value 100.67.
Also, the second parameter of Html.Table is a list of name-selector pairs, not a record. So you should use
let
html = "<table><tr><td>100.67</td></tr></table>",
#"Extracted Table" = Html.Table(html, {{"myValue", "td"}})
in
#"Extracted Table"
gvg
3 years agoPost Prodigy
Yes, you are right. Thank you!