Difference between revisions of "HTML ENTITY DECODE()"

From Lianjapedia
Jump to: navigation, search
 
(2 intermediate revisions by one other user not shown)
Line 1: Line 1:
 
==Purpose==
 
==Purpose==
 
Function to return a string from a character string or memo field where numeric html entities have been replaced with their display character equivalents
 
Function to return a string from a character string or memo field where numeric html entities have been replaced with their display character equivalents
 
  
 
==Syntax==
 
==Syntax==
 
HTML_ENTITY_DECODE(<expC> | <memofield>)
 
HTML_ENTITY_DECODE(<expC> | <memofield>)
 
  
 
==See Also==
 
==See Also==
[[ASC()]], [[AT()]], [[ATNEXT()]], [[CHR()]], [[CHRTRAN()]], [[DECODE()]], [[ENCODE()]], [[HTML_ENTITIES()]], [[INLIST()]], [[LEFT()]], [[OCCURS()]], [[RAT()]], [[RIGHT()]], [[STR()]], [[STR_REPLACE()]], [[STREXTRACT()]], [[STRTRAN()]], [[STUFF()]], [[SUBSTR()]]
+
[[ASC()]], [[AT()]], [[ATNEXT()]], [[CHR()]], [[CHRTRAN()]], [[DECODE()]], [[ENCODE()]], [[HTML_ENTITIES()]], [[HTML_TOPLAINTEXT()]], [[INLIST()]], [[LEFT()]], [[OCCURS()]], [[RAT()]], [[RIGHT()]], [[STR()]], [[STR_REPLACE()]], [[STREXTRACT()]], [[STRTRAN()]], [[STUFF()]], [[SUBSTR()]]
 
+
  
 
==Description==
 
==Description==
 
The HTML_ENTITY_DECODE() function will search <expC> or <memofield> and return a string where numeric html entities have been replaced with their display character equivalents.  
 
The HTML_ENTITY_DECODE() function will search <expC> or <memofield> and return a string where numeric html entities have been replaced with their display character equivalents.  
 
  
 
==Example==
 
==Example==
Line 21: Line 17:
 
</code>
 
</code>
  
==Products==
 
Lianja, Lianja SQL Server, Lianja Cloud Server
 
 
[[Category:Documentation]]
 
[[Category:Documentation]]
 
[[Category:Functions]]
 
[[Category:Functions]]
[[Category:String Data]]
 
 
[[Category:String Data Functions]]
 
[[Category:String Data Functions]]
 
[[Category:HTML Functions]]
 
[[Category:HTML Functions]]

Latest revision as of 09:23, 20 September 2016

Purpose

Function to return a string from a character string or memo field where numeric html entities have been replaced with their display character equivalents

Syntax

HTML_ENTITY_DECODE(<expC> | <memofield>)

See Also

ASC(), AT(), ATNEXT(), CHR(), CHRTRAN(), DECODE(), ENCODE(), HTML_ENTITIES(), HTML_TOPLAINTEXT(), INLIST(), LEFT(), OCCURS(), RAT(), RIGHT(), STR(), STR_REPLACE(), STREXTRACT(), STRTRAN(), STUFF(), SUBSTR()

Description

The HTML_ENTITY_DECODE() function will search <expC> or <memofield> and return a string where numeric html entities have been replaced with their display character equivalents.

Example

? html_entity_decode("&#123;")
{