Brian Dunning's FileMaker Custom Functions

decodeEntities ( text )

Convert HTML entities (example &#'64';) to text (In this case a @)

  Average rating: 3.7 (3 votes) Log in to vote

Enzo Borri   Enzo Borri
http://Borri.org

Share on Facebook Share on Twitter

  Sample input:
decodeEntities ("john@doe.com")
  Sample output:
john@doe.com

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

Getting email addresses from web pages, I found they were encoded using HTML entities (such as "&#'64';" instead than "@"). Using this function I'm now able to transform email addresses formatted like "john@doe.com" to their readable form like "john@doe.com"

 

Comments

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.