Difference between revisions of "MTOS()"
From Lianjapedia
Yvonne.milne (Talk | contribs) |
|||
(7 intermediate revisions by 4 users not shown) | |||
Line 1: | Line 1: | ||
==Purpose== | ==Purpose== | ||
Function to convert a memo field to character data type | Function to convert a memo field to character data type | ||
− | |||
==Syntax== | ==Syntax== | ||
MTOS(<memofield>) | MTOS(<memofield>) | ||
− | |||
==See Also== | ==See Also== | ||
− | [[ | + | [[ATOM()]], [[HTML_TOPLAINTEXT()]], [[MEMLINES()]], [[MEMOLINE()]], [[MEMOREAD()]], [[MEMOTRAN()]], [[MEMOWRITE()]], [[MLCOUNT()]], [[MLINE()]], [[MTOA()]], [[SET MEMOWIDTH]], [[SET STRESCAPE]], [[STRTRAN()]], [[SUBSTR()]] |
− | + | ||
==Description== | ==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 (""). | 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== | ==Example== | ||
<code lang="recital"> | <code lang="recital"> | ||
− | |||
string = mtos(notes) | string = mtos(notes) | ||
string = string + chr(10) + "AT" + date() +" " + time() | string = string + chr(10) + "AT" + date() +" " + time() | ||
Line 23: | Line 18: | ||
</code> | </code> | ||
− | |||
− | |||
− | |||
[[Category:Documentation]] | [[Category:Documentation]] | ||
[[Category:Functions]] | [[Category:Functions]] | ||
− | [[Category: | + | [[Category:Formatting Functions]] |
[[Category:String Data Functions]] | [[Category:String Data Functions]] | ||
− | |||
− | |||
− | |||
[[Category:Memos Functions]] | [[Category:Memos Functions]] | ||
+ | [[Category:Lianja VFP Extensions]] | ||
+ | [[Category:VFP Function Extensions]] |
Latest revision as of 09:27, 20 September 2016
Contents
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