ExtractTableCell ( HTML ; cellNumber )

Returns the contents of the specified cell in HTML table.

Average rating: 3.9 (48 votes) Log in to vote

Michael Horak - Show more from this author
*COMMENT Visual Realisation

Sample input:

ExtractTableCell (
"<html>
<body>
<table>
<tr>
<td>Cell A</td>
<td>Cell B</td>
</tr>
</body>
</html>"
;
2 )

Sample output:

Cell B

Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

/*
ExtractTableCell function

Author
*COMMENT Visual Realisation

Format
ExtractTableCell ( HTML ; cellNumber )

Parameters
HTML - any text expression or text field
cellNumber - any numeric expression, or field containing a number, representing the number of the cell from the start of HTML

Data type returned
text

Description
Returns the contents of the specified cell in HTML table. Cells are counted from the beginning of the HTML code, ignoring table and row declarations.

For example, if there are two tables of 2 rows by 3 columns each, cellNumber 8 refers to the cell in the first row, second column of the second table.

January 21, 2007
*/

Let ( [ 
cellStart = Position ( HTML ; "<TD" ; 1 ; cellNumber ) ;
dataStart = Position ( HTML ; ">" ; cellStart ; 1 ) + 1 ;
dataEnd = Position ( HTML ; "</TD" ; dataStart ; 1 ) ;

cellCount = PatternCount ( HTML ; "<TD" ) 
] ;
Case ( 1 ≤ cellNumber and cellNumber ≤ cellCount ; Middle ( HTML ; dataStart ; dataEnd - dataStart ) )
)

Returns the contents of the specified cell in HTML table. Cells are counted from the beginning of the HTML code, ignoring table and row declarations.

For example, if the HTML code contains two tables of 2 rows by 3 columns each, cellNumber 8 refers to the cell in the first row, second column of the second table.

This function is not recursive.

Comments

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.

ExtractTableCell ( HTML ; cellNumber )

Comments

Support this website.

Support this website.