CF_HTMLtoFMP_styledText_sub ( text ; openTag ; closeTag ; replaceWith )

Converts data between predefined HTML tags into FMP bold / italic etc. As well as standard HTML tags, you can also define your own custom tags.

Average rating: 4.6 (32 votes) Log in to vote

Chaim Bacon - Show more from this author
SeekUnique
http://www.seekunique.co.uk

Sample input:

This custom function is subordinate to the CF_HTMLtoFMP_styledText custom function. All parameters are passed from the parent custom function.

Sample output:

See parent custom function for sample or download the demo file from our website at:

http://www.productiveit.co.uk/files/HTML_to_FileMaker_styled_text.zip

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

/*
This custom function converts data between PREDEFINED HTML TAGS into FMP bold / italic etc.

NOTE: This custom function is called by another custom function 'CF_HTMLtoFMP_styledText', it does not work on its own.

Created by Chaim Bacon
SeekUnique Software Ltd.
chaim@seekunique.co.uk
+44 (0)1923 944 444
*/


Let ([
lenOpen = Length( openTag );
lenClose = Length( closeTag );
ptOpen = Position(text; openTag ; 1; 1);
ptClose = Position(text; closeTag ; ptOpen + lenOpen; 1) + lenClose;
startText = Left(text; ptOpen - 1);
$text = Middle ( text ; ptOpen + lenOpen  ; ptClose - lenClose - lenOpen - ptOpen  ) ; 

replaceText = Evaluate ( replaceWith ) ;  
 
remainText = Middle( text; ptClose; 9999999)]; 

Case( lenOpen > 0 and lenOpen > 0 and ptOpen > 0 and ptClose > lenClose;
startText & replaceText & CF_HTMLtoFMP_styledText_sub ( remainText ; openTag ; closeTag ; replaceWith )
 ; text))

See description in custom function above.

NOTE: The other custom function 'CF_HTMLtoFMP_styledText' is required for this one to work.

You can download a fully working sample file of this function at:
https://www.dropbox.com/s/slkfotd4wtlyxpq/HTML_to_FM_Styled_Text.fmp12?dl=0

Comments

		Mark D Kerr, Discovery Reef Design & Consulting Jul 28, 2021
Appears to be non-functional in FM19 on Windows 10.

		Chaim Bacon, SeekUnique Jul 28, 2021
Hi Mark, I have made a new sample file and it works as expected way back when it was written in 2008. Tested on Mac with FM 19 but can't see why it wouldn't work on Win or any version of FM. Please use this link to download: https://www.dropbox.com/s/slkfotd4wtlyxpq/HTML_to_FM_Styled_Text.fmp12?dl=0

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

CF_HTMLtoFMP_styledText_sub ( text ; openTag ; closeTag ; replaceWith )

Comments

Support this website.

Support this website.