Skip to main content

parseHTMLTable

parseHTMLTable [column]

Extracts tables from a provided html column and converts them to JSON rows of objects.

arguments:

column

The column to extract the html table from. Ensure that the html contains the <table></table> tags. If using the open command with the --html or --hashtml flag, the valid html will be contained in the outerHTML column (type: string)

examples:

Query

seed "[{outerHTML: '&lt;table&gt;&lt;tr&gt;&lt;th&gt;header&lt;/th&gt;&lt;/tr&gt;&lt;tr&gt;&lt;td&gt;cell&lt;/td&gt;&lt;/tr&gt;&lt;/table&gt;'}]"
|| parseHTMLTable outerHTML

Results prior to parseHTMLTable stage:

outerHTML
<table><tr><th>header</th></tr><tr><td>cell</td></tr></table>

Results after parseHTMLTable stage:

headerhash
cellcb65594c925126a566b208c52a0b30eb051d39876cd5653aa374b00a5e41c2a6

flags:

--hash

Add a hash column to the results

--row

Add a table row number column to the results

--sequence

Add a sequence column to the results

support

AMI_ENTERPRISE AMI_FREE AMI_PRO BINARY_ENTERPRISE BINARY_FREE BINARY_PRO DESKTOP_ENTERPRISE DESKTOP_FREE DESKTOP_PRO DOCKER_ENTERPRISE DOCKER_FREE DOCKER_PRO