DECODE()

From Lianjapedia
Revision as of 06:32, 4 February 2013 by Helen.george (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

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;")
{