Description
Removes all nonprintable characters from the supplied text.
Syntax
CLEAN ( text )
| Parameter | Description |
|---|---|
| text | Any 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")
See also