Description
Emulates Excel’s CLEAN function by removing all non-printable characters from text.
Specifically, CLEAN() removes ASCII characters 1 to 31 and characters 129, 141, 143, 144 and 157.
Syntax
CLEAN(<input>)
Arguments
| Argument | Type | Description | Optional |
|---|---|---|---|
| input | Text | The text value to clean. | No |
Returns
Text
Examples
| Expression: | CLEAN("The quick brown |
| Returns: | The quick brown fox |