You can configure a step to change the character case in a data field.
1On the Configuration tab of the cleanse asset, click Add Step.
2Select the Convert Case option.
3In the step properties pane, select one of the following casing styles:
- Upper Case
- Lower Case
- Toggle Case
- Sentence Case
- Title Case
4If you select the Lower Case, Toggle Case, Sentence Case, or Title Case option, specify one or more delimiters for the input data. Optionally, select one or more dictionaries to apply to the input data.
If you select a dictionary, select a valid column for the dictionary. In addition to converting the character case, the asset replaces any value in a non-valid dictionary column with the corresponding value in the valid column.
5Optionally, select or clear the option to leave uppercase words unchanged.