Difference between revisions of "ENCODE()"
From Lianjapedia
Helen.george (Talk | contribs) |
Yvonne.milne (Talk | contribs) |
||
Line 6: | Line 6: | ||
==See Also== | ==See Also== | ||
− | [[ASC()]], [[AT()]], [[ATNEXT()]], [[CHR()]], [[CHRTRAN()]], [[DECODE()]], [[HTML_ENTITIES()]], [[HTML_ENTITY_DECODE()]], [[INLIST()]], [[LEFT()]], [[OCCURS()]], [[RAT()]], [[RIGHT()]], [[STR()]], [[STR_REPLACE()]], [[STREXTRACT()]], [[STRTRAN()]], [[STUFF()]], [[SUBSTR()]] | + | [[ASC()]], [[AT()]], [[ATNEXT()]], [[CHR()]], [[CHRTRAN()]], [[DECODE()]], [[HTML_ENTITIES()]], [[HTML_ENTITY_DECODE()]], [[INLIST()]], [[LEFT()]], [[OCCURS()]], [[RAT()]], [[RIGHT()]], [[STR()]], [[STR_ESCAPE()]], [[STR_REPLACE()]], [[STREXTRACT()]], [[STRTRAN()]], [[STUFF()]], [[SUBSTR()]] |
==Description== | ==Description== |
Latest revision as of 11:48, 1 December 2014
Contents
Purpose
Function to return a string from a character string or memo field where qualifying characters have been replaced with their html entity equivalents
Syntax
ENCODE(<expC> | <memofield>)
See Also
ASC(), AT(), ATNEXT(), CHR(), CHRTRAN(), DECODE(), HTML_ENTITIES(), HTML_ENTITY_DECODE(), INLIST(), LEFT(), OCCURS(), RAT(), RIGHT(), STR(), STR_ESCAPE(), STR_REPLACE(), STREXTRACT(), STRTRAN(), STUFF(), SUBSTR()
Description
The ENCODE() function will search <expC> or <memofield> and return a string where qualifying characters have been replaced with their html entity equivalents.
The following characters are converted to their HTML entity equivalents:
- Tab (chr(9))
- Line feed (chr(10))
- Carriage return (chr(13))
- "
- &
- '
- <
- >
Example
<!-- dispmemo.rsp --> <html> <body> <% open database southwind use example goto 1 ? "<pre>" + encode(notes) + "</pre>" close databases %> </body> </html>