CLEAN (Primitive Spread Function) removes all non-printable characters from text.

SYNTAX:

CLEAN(text)

REMARKS:

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

EXAMPLES:

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

CLEAN( Chr(7) + "text" + Chr(7) ) equals text