This function removes all non-printable characters from text.
CLEAN(text)
The text argument is any data from which you want to remove non-printable characters.
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
Accepts string data. Returns string data.
In this example, CHR(7) returns a non-printable character
CLEAN(CHAR(7)&"text"&CHAR(7)) gives the result text