Hi, I'm Ask INFA!
What would you like to know?
ASK INFAPreview
Please to access Ask INFA.

Cleanse assets

Cleanse assets

Removing character spaces from the data

Removing character spaces from the data

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.
  1. On the
    Configuration
    tab of the cleanse asset, click
    Add Step
    .
  2. Select the
    Remove Spaces
    option.
  3. 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.
  4. Save the asset.

0 COMMENTS

We’d like to hear from you!