ISO FileMaker Magazine

Thanks Matt, Looking forward to the video on connecting to API.

I'll try again later, but no joy right now.

Using bBox > Python > BeautifulSoup doesn’t always capture the full function text from html.

The problem arrises when the function contains a ‘<‘ symbol. This class of symbols aren’t properly converted to html entities within the function's web page on BrianDunning.com.

When BeautifulSoup encounters the misplaced symbols, it tries to accommodate by assuming them to be tag related. This results in a corrupt/inaccurate html tree structure.

The Python script returns the function text up to the first “<“.

This “Recapture” Filemaker script can be applied when needed.

# Sometimes the Python/BeautifulSoup capture of the function body fails.
# This can happen if the text contains reserved HTML characters that have not been converted to entities.

Set Variable [ $result; Value:Let ([
~content = Functions::html;
~match = ""; ~start; 1)
];
Let ([
~content = Middle ( ~content; ~start; ~end - ~start );
~match = ">";
~start = Position ( ~content; ~match; 1; 1 ) + Length ( ~match );
~end = Length ( ~content ) + 1
];
Substitute ( Middle ( ~content; ~start; ~end - ~start ) ; Char(10) ; "" )
)
)]
Set Field [ Functions::function; $result ]