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 - Show more from this author
Studio Gatzki

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 ...



Ward Clark   Ward Clark, Dancing Bears
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 Please contact the individual developer with any questions or problems.

Support this website.

This library has been a free commmunity resource for FileMaker users and developers for 16 years. It receives no funding and has no advertisements. If it has helped you out, I'd really appreciate it if you could contribute whatever you think it's worth: