CLEAN

The CLEAN Function

Function Group: Text

CLEAN removes any control ASCII characters from the input argument.

Syntax

CLEAN(arg1)

• arg1 is a string to be cleaned

Uses

Control (or non-printable) characters are not printed by nature, so implementers of the CLEAN function will likely not see any visible difference. To test the CLEAN function, control characters can be inserted into a string using the CHAR function:

CLEAN("TEST" + CHAR(13))

This would return "TEST" without the carriage return character.