You can configure a step to remove extraneous and redundant character spaces from a data field. The step does not remove instances of single spaces between values in the field.
On the
Configuration
tab of the cleanse asset, click
Add Step
.
Select the
Remove Spaces
option.
Select one or both of the following options:
Leading and trailing spaces. Removes one or more character spaces at the start or the end of the string.
Multiple spaces. Replaces instances of two or more spaces with a single space.