Newest functions Upload a function Leave a tip My account

There are 2,572 functions in this library.

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 - Show more from this author Studio Gatzki http://www.gatzki.de

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

Substitute ( Text; [ """ ; " "]; [ "&" ; "&"]; [ "<" ; "<"]; [ ">" ; ">"]; [ " " ; ""]; [ "¡" ; "¡"]; [ "¢" ; "¢"]; [ "£" ; "£"]; [ "¤" ; "¤"]; [ "¥" ; "¥"]; [ "¦" ; "¦"]; [ "§" ; "§"]; [ "¨" ; "¨"]; [ "©" ; "©"]; [ "ª" ; "ª"]; [ "«" ; "«"]; [ "¬" ; "¬"]; [ "­" ; "­"]; [ "®" ; "®"]; [ "¯" ; "¯"]; [ "°" ; "°"]; [ "±" ; "±"]; [ "²" ; "²"]; [ "³" ; "³"]; [ "´" ; "´"]; [ "µ" ; "µ"]; [ "¶" ; "¶"]; [ "·" ; "·"]; [ "¸" ; "¸"]; [ "¹" ; "¹"]; [ "º" ; "º"]; [ "»" ; "»"]; [ "¼" ; "¼"]; [ "½" ; "½"]; [ "¾" ; "¾"]; [ "¿" ; "¿"]; [ "À" ; "À"]; [ "Á" ; "Á"]; [ "Â" ; "Â"]; [ "Ã" ; "Ã"]; [ "Ä" ; "Ä"]; [ "Å" ; "Å"]; [ "Æ" ; "Æ"]; [ "Ç" ; "Ç"]; [ "È" ; "È"]; [ "É" ; "É"]; [ "Ê" ; "Ê"]; [ "Ë" ; "Ë"]; [ "Ì" ; "Ì"]; [ "Í" ; "Í"]; [ "Î" ; "Î"]; [ "Ï" ; "Ï"]; [ "Ð" ; "Ð"]; [ "Ñ" ; "Ñ"]; [ "Ò" ; "Ò"]; [ "Ó" ; "Ó"]; [ "Ô" ; "Ô"]; [ "Õ" ; "Õ"]; [ "Ö" ; "Ö"]; [ "×" ; "×"]; [ "Ø" ; "Ø"]; [ "Ù" ; "Ù"]; [ "Ú" ; "Ú"]; [ "Û" ; "Û"]; [ "Ü" ; "Ü"]; [ "Ý" ; "Ý"]; [ "Þ" ; "Þ"]; [ "ß" ; "ß"]; [ "à" ; "à"]; [ "á" ; "á"]; [ "â" ; "â"]; [ "ã" ; "ã"]; [ "ä" ; "ä"]; [ "å" ; "å"]; [ "æ" ; "æ"]; [ "ç" ; "ç"]; [ "è" ; "è"]; [ "é" ; "é"]; [ "ê" ; "ê"]; [ "ë" ; "ë"]; [ "ì" ; "ì"]; [ "í" ; "í"]; [ "î" ; "î"]; [ "ï" ; "ï"]; [ "ð" ; "ð"]; [ "ñ" ; "ñ"]; [ "ò" ; "ò"]; [ "ó" ; "ó"]; [ "ô" ; "ô"]; [ "õ" ; "õ"]; [ "ö" ; "ö"]; [ "÷" ; "÷"]; [ "ø" ; "ø"]; [ "ù" ; "ù"]; [ "ú" ; "ú"]; [ "û" ; "û"]; [ "ü" ; "ü"]; [ "ý" ; "ý"]; [ "þ" ; "þ"]; [ "ÿ" ; "ÿ"]) Click to copy

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

Support this website.

This library has been a free commmunity resource for FileMaker users and developers for 21 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: