MEMOTRAN()

    MEMOTRAN() replaces carriage return/line feed pairs.

Syntax

    MEMOTRAN (<expC1>[,<expC2>[,<expC3>]])

Arguments

    <expC1> is the character string or memo field to replace soft or hard
    carriage returns in.

    <expC2> is the character you specify to replace a hard carriage
    return/line feed pair.

    <expC3> is the character you specify to replace a soft carriage
    return/line feed pair.

Returns

    A character string.

    If you do not specify <expC2> and <expC3>, MEMOTRAN() replaces all hard
    carriage returns (CHR(13)) with semicolons, all soft carriage returns
    (CHR(141) with spaces, and eliminates all line feeds.

Usage

    The default replacement values accommodate the requirements of the
    REPORT FORM command.

    If you invoke a REPORT FORM that uses MEMOTRAN() and do not use
    MEMOTRAN() anywhere else in the program, be sure to declare MEMOTRAN()
    to the linker with EXTERNAL.

Example

    To strip all formatting characters from a memofield:

            REPLACE Notes WITH MEMOTRAN(Notes," "," ")