HTML TOPLAINTEXT()

From Lianjapedia
Revision as of 03:59, 28 September 2016 by Yvonne.milne (Talk | contribs)

Jump to: navigation, search

Purpose

Function to return a string from a character string or memo field where html markup has been removed

Syntax

HTML_TOPLAINTEXT(<expC> | <memofield> [, <expL>])

See Also

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

Description

The HTML_TOPLAINTEXT() function will search <expC> or <memofield> and return a plain text string where html markup has been removed. If the optional <expL> is .T. (true), newlines are retained.

Example

open database southwind
use employees
? html_toplaintext(notes,.T.)