CLEAN

Removes all non-printable characters from text.

Examples

• CLEAN(“Hello”&CHAR(7)) - Returns “Hello”.
• CLEAN(“Good”&CHAR(13)&“Day”) - Returns “GoodDay”.
• CLEAN(“Text”&CHAR(10)&“More”) - Returns “TextMore”.