, , )

---

The htmltablerow( function extracts the data from a row in an HTML table.

---

Parameters

This function has three parameters:

table – text of the HTML table. If this parameter contains the body of an HTML table, the table must contain <tr> and <td> tags (however, the actual <table> and </table> tags themselves are not required).

row – row number within HTML table. Rows are numbered starting from 1.

separator – the separator character for the output array.

---

Description

This function extracts the data from a row in an HTML table. Suppose you set up a variable with an HTML table, like this:

local htable
htable = 
    "<tr><td><font size=-1>Alaska</font></td><td>AK</td></tr>
    <tr><td><font size=-1>Arizona</font></td><td>AR</td></tr>
    <tr><td><font size=-1>Wyoming</font></td><td>WY</td></tr>"

Once this variable is set up, you can extract different table elements using the htmltablerow( function.

htmltablerow(htable,1,",") ☞ Alaska,AK
htmltablerow(htable,3,",") ☞ Wyoming,WY

This function removes any HTML tags in the row (in the example above, removing the font tags). If you want to keep the tags, use the htmltablerowraw( function.

htmltablerowraw(htable,1) ☞ <td><font size=-1>Alaska</font></td><td>AK</td>
htmltablerowraw(htable,3) ☞ <td><font size=-1>Wyoming</font></td><td>WY</td>

Note: This function is equivalent to:

tagstrip(tagarray(arrayrange(tagdata(thetable,"<tr","</tr>",therow),2,9999,">"),"<td>","</td>",thesep),"<",">")

---

See Also

• HTML Export -- custom exports into an HTML file.
• htmlarraytable -- generates an HTML table from an arrray.
• htmldatamerge -- uses a template to generate HTML you want from a database.
• htmldatatable -- generates an HTML table from selected data in the current database.
• htmlextractimages -- extracts the image URLs from an HTML page.
• htmlextractlinks -- extracts the links from an HTML page.
• htmlformitemnames -- returns a list of form input elements (*INPUT* tags, etc.) within an HTML page.
• htmltablecell( -- extracts the data from a cell in an HTML table.
• htmltablecellexists( -- returns true if an HTML table contains the specified cell, false if it doesn't.
• htmltablecellraw( -- extracts the data from a cell in an HTML table (including tags, if any).
• htmltableheight( -- calculates the height (number of rows) in an HTML table.
• htmltablerowraw( -- extracts the raw data (including tags, if any) from a row in an HTML table.
• htmltabletoarray -- converts an HTML table into a text array.
• htmltablewidth( -- calculates the width (number of columns) in an HTML table.
• xtag( -- generates an HTML/XML tag.

---

History

Version	Status	Notes
10.0	New	New in this version.