CLEAN

CLEAN removes any control ASCII characters from the input argument.

Control (or non-printable) characters are not normally printed, so when using the CLEAN function visible differences will not likely be seen.

Function category: Text

Syntax

CLEAN(arg1)

Arguments

Description

arg1

String to be cleaned.

Example

If we want to test the CLEAN function, control characters can be inserted into a string using the CHAR function, using the following function.

# Test the function
CLEAN("TEST" + CHAR(13))
# Returns "TEST"
# (without a carriage return character)