Forum Discussion

gvg's avatar
gvg
Post Prodigy
3 years ago
Solved

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...
Show and Tell
  • nitishsh91's avatar
    nitishsh91
    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"

     

nitishsh91's avatar
nitishsh91
Solution Supplier
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"