Brian Dunning's FileMaker Custom Functions

HTML_to_Text ( Text )

Convert named entities in HTML to Text ( ISO 8859-1)

  Average rating: 3.8 (37 votes) Log in to vote

Oliver Gatzki   Oliver Gatzki
Studio Gatzki
http://www.gatzki.de

Share on Facebook Share on Twitter

  Sample input:
HTML_to_Text( Text
//including f.e.& or   )
  Sample output:
& öüä etc.

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

Converting named entities in HTML to Text ( ISO8859-1)
There might be some entities i haven´t included, like the mathematical entities ...

 

Comments

Ward Clark   Ward Clark, Massachusetts, USA
Aug 22, 2009
All of the Substitute pairs are identical. It appears the HTML character entities got translated to actual characters somewhere along the way.
 
Guillaume Dreux   Guillaume Dreux, Pau/France
Jul 8, 2011
This function doesn't work actually.

To make it work, you have to modify the first caracter to substitute.
So it should look like Substitute ( Text; ["\""; " "]; ect ...

By the way, thanks for the function !
 

Log in to post comments.

 

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

Under construction. Email me your wish list for improvements.