MTOS()

From Lianjapedia
Revision as of 08:27, 20 September 2016 by Yvonne.milne (Talk | contribs)

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

Purpose

Function to convert a memo field to character data type

Syntax

MTOS(<memofield>)

See Also

ATOM(), HTML_TOPLAINTEXT(), MEMLINES(), MEMOLINE(), MEMOREAD(), MEMOTRAN(), MEMOWRITE(), MLCOUNT(), MLINE(), MTOA(), SET MEMOWIDTH, SET STRESCAPE, STRTRAN(), SUBSTR()

Description

The MTOS() function converts the memo field <memofield> to a character data type. This function is particularly useful for modifying fields globally. If the specified <memofield> is empty, the MTOS() function returns a null string ("").

Example

string = mtos(notes)
string = string + chr(10) + "AT" + date() +" " + time()
replace notes with string