Skip to content

Instantly share code, notes, and snippets.

@TiagoGouvea
Created January 12, 2024 17:03
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save TiagoGouvea/5b709c922871bc0c3a88f142ad55fc4a to your computer and use it in GitHub Desktop.
Save TiagoGouvea/5b709c922871bc0c3a88f142ad55fc4a to your computer and use it in GitHub Desktop.
HTML entities decode for Google App Script
function htmlEntitiesDecode(input) {
entities.forEach(function(substitution) {
var regex = new RegExp(substitution.entity, 'g');
input = input.replace(regex, substitution.character);
});
return input;
}
const entities = [
{ entity: "À", character: "À" },
{ entity: "Á", character: "Á" },
{ entity: "Â", character: "Â" },
{ entity: "Ã", character: "Ã" },
{ entity: "Ä", character: "Ä" },
{ entity: "Å", character: "Å" },
{ entity: "à", character: "à" },
{ entity: "á", character: "á" },
{ entity: "â", character: "â" },
{ entity: "ã", character: "ã" },
{ entity: "ä", character: "ä" },
{ entity: "å", character: "å" },
{ entity: "Æ", character: "Æ" },
{ entity: "æ", character: "æ" },
{ entity: "ß", character: "ß" },
{ entity: "Ç", character: "Ç" },
{ entity: "ç", character: "ç" },
{ entity: "È", character: "È" },
{ entity: "É", character: "É" },
{ entity: "Ê", character: "Ê" },
{ entity: "Ë", character: "Ë" },
{ entity: "è", character: "è" },
{ entity: "é", character: "é" },
{ entity: "ê", character: "ê" },
{ entity: "ë", character: "ë" },
{ entity: "ƒ", character: "ƒ" },
{ entity: "Ì", character: "Ì" },
{ entity: "Í", character: "Í" },
{ entity: "Î", character: "Î" },
{ entity: "Ï", character: "Ï" },
{ entity: "ì", character: "ì" },
{ entity: "í", character: "í" },
{ entity: "î", character: "î" },
{ entity: "ï", character: "ï" },
{ entity: "Ñ", character: "Ñ" },
{ entity: "ñ", character: "ñ" },
{ entity: "Ò", character: "Ò" },
{ entity: "Ó", character: "Ó" },
{ entity: "Ô", character: "Ô" },
{ entity: "Õ", character: "Õ" },
{ entity: "Ö", character: "Ö" },
{ entity: "ò", character: "ò" },
{ entity: "ó", character: "ó" },
{ entity: "ô", character: "ô" },
{ entity: "õ", character: "õ" },
{ entity: "ö", character: "ö" },
{ entity: "Ø", character: "Ø" },
{ entity: "ø", character: "ø" },
{ entity: "Œ", character: "Œ" },
{ entity: "œ", character: "œ" },
{ entity: "Š", character: "Š" },
{ entity: "š", character: "š" },
{ entity: "Ù", character: "Ù" },
{ entity: "Ú", character: "Ú" },
{ entity: "Û", character: "Û" },
{ entity: "Ü", character: "Ü" },
{ entity: "ù", character: "ù" },
{ entity: "ú", character: "ú" },
{ entity: "û", character: "û" },
{ entity: "ü", character: "ü" },
{ entity: "µ", character: "µ" },
{ entity: "×", character: "×" },
{ entity: "Ý", character: "Ý" },
{ entity: "Ÿ", character: "Ÿ" },
{ entity: "ý", character: "ý" },
{ entity: "ÿ", character: "ÿ" },
{ entity: "°", character: "°" },
{ entity: "†", character: "†" },
{ entity: "‡", character: "‡" },
{ entity: "&lt;", character: "<" },
{ entity: "&gt;", character: ">" },
{ entity: "&#177;", character: "±" },
{ entity: "&#171;", character: "«" },
{ entity: "&#187;", character: "»" },
{ entity: "&#191;", character: "¿" },
{ entity: "&#161;", character: "¡" },
{ entity: "&#183;", character: "·" },
{ entity: "&#149;", character: "•" },
{ entity: "&#153;", character: "™" },
{ entity: "&copy;", character: "©" },
{ entity: "&reg;", character: "®" },
{ entity: "&#167;", character: "§" },
{ entity: "&#182;", character: "¶" },
{ entity: "&quot;", character: "\"" },
{ entity: "&nbsp;", character: " " },
{ entity: "&ndash;", character: "-" },
{ entity: "&amp;", character: "&" },
{ entity: "&ldquo;", character: "“" },
{ entity: "&bull;", character: "•" },
{ entity: "&rdquo;", character: "”" },
{ entity: "&ordf;", character: "ª" },
{ entity: "&ordm;", character: "º" },
{ entity: "&ordf;", character: "ª" },
{ entity: "&ordf;", character: "ª" },
{ entity: "&ordf;", character: "ª" },
{ entity: "&ordf;", character: "ª" },
{ entity: "&ordf;", character: "ª" },
];
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment