CLEAN

CLEAN removes any control ASCII characters from the input argument.

Function category: Text

Syntax

CLEAN(arg1)

Arguments

Description

arg1

String to be cleaned.

Example

Control (or non-printable) characters are not normally printed, so when using the CLEAN function visible differences will not likely be seen. To test the CLEAN function, control characters can be inserted into a string using the CHAR function as follows:

CLEAN("TEST" + CHAR(13))

This returns the following string without the carriage return character:

"TEST"