CLEAN

Description

CLEAN removes all nonprintable characters from the supplied text.

Syntax

CLEAN ( text )

Remarks

Text that is imported from another environment may require this function.

Examples

This function returns Payments Due because the character returned by CHAR (8) is nonprintable:

CLEAN("Payments " & CHAR(8) & "Due")

Nonprintable characters

CHAR (n), where n = 1-9, 11-31,127, 129, 141, 143, 144 or 157.

Also, see

CHAR

TRIM