Preface
Introduction to cleanse assets
Step configuration
Merge configuration
- Merge configuration options
- Merging records
Test cleanse assets
- Testing a cleanse instance
  - Rules and guidelines for test data
- Testing the merge operation

Cleanse assets

Back Next

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.

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.

Save the asset.

Step configuration

Download Guide

Watch

Comments

Cloud Data Quality Homepage

0 COMMENTS

We’d like to hear from you! Log in to comment.

Rename Saved Search

Table of Contents

Cleanse assets

Cleanse assets

Removing character spaces from the data

Removing character spaces from the data