Spread.NET 17 Formula Reference
Formula Functions / Functions A to C / CLEAN
In This Topic
    CLEAN
    In This Topic

    This function removes all non-printable characters from text.

    Syntax

    CLEAN(text)

    Arguments

    The text argument is any data from which you want to remove non-printable characters.

    Remarks

    Use this function to remove text that contains characters that might not print with your operating system. For example, you can use this function to remove some low-level computer code, which is frequently at the beginning and end of data files and cannot be printed

    Data Types

    Accepts string data. Returns string data.

    Example

    In this example, CHR(7) returns a non-printable character

    CLEAN(CHAR(7)&"text"&CHAR(7)) gives the result text

    Version Available

    This function is available in product version 1.0 or later.

    See Also

    TRIM | SUBSTITUTE | Text Functions