Formula Functions > Functions A to C > CLEAN |
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
This function is available in product version 1.0 or later.
TRIM | SUBSTITUTE | Text Functions