CLEAN
Syntax
CLEAN (string_expression)
Description
Takes a string expression as input and returns the expression with all non-printable characters removed.
Arguments
| string_expression | Any string data. |
Returns
A String with any non-printable characters removed.
Remarks
Non-printable characters are those with a Hex value of less than 0x32.
Example
MyEntity.Name contains the following value:
"ACME Test Co □"
This value contains a character that cannot be printed, which displays as a white square (□).
The following formula:
CLEAN(MyEntity.Name)
Returns: "ACME Test Co"