Difference between revisions of "DECODE()"

From Recital Documentation Wiki
Jump to: navigation, search
 
 
Line 8: Line 8:
  
 
==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()]], [[ENCODE()]], [[HTML_ENTITIES()]], [[INLIST()]], [[LEFT()]], [[OCCURS()]], [[RAT()]], [[RIGHT()]], [[STR()]], [[STR_REPLACE()]], [[STREXTRACT()]], [[STRTRAN()]], [[STUFF()]], [[SUBSTR()]]
  
  

Latest revision as of 14:27, 1 July 2011

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

DECODE(<expC> | <memofield>)


See Also

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


Description

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


Example

? decode("&#123;")
{

Products

Recital Web, Recital Server, Recital