CLEAN

This function removes all non-printable characters from text.

Syntax

CLEAN(text)

Arguments

[Required] 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

Example

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

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