CLEAN function
This topic describes the formula syntax and usage of the CLEAN function in the Data Quality Execute Formula transform.
Description
Removes all unprintable characters from text. Use CLEAN on text from other data sources that contains the first 32 nonprinting characters in 7-bit ASCII code (values 0 through 31).
Important: The CLEAN function was designed to remove the first 32 nonprinting characters in the 7-bit ASCII code (values 0 through 31) from text. In the Unicode character set, there are additional nonprinting characters (values 127, 129, 141, 143, 144, and 157). By itself, the CLEAN function does not remove these additional nonprinting characters.
Syntax
CLEAN(text)The CLEAN function syntax has the following argument:
TextRequired. Any field information from which you want to remove nonprinting characters.
Example
Data: Address field contains a TAB (9) character after the space between the street number and street name:
1600 Pennsylvania Avenue| Formula | Description | Result |
|---|---|---|
| CLEAN([Address]) | Removes nonprintable characters from the Address field in a dataset. |
1600 Pennsylvania Avenue |