Cleanse assets

Back Next

Removing instances of one or more values that you specify

You can configure a step to remove instances of one or more values that you specify from a data field.

On the

Configuration

tab of the cleanse asset, click

Add Step

Select the

Remove Values

option.

In the step properties pane, select

Remove Custom Strings

Verify the delimiter that the mapping will use to recognize discrete values in the input field. You can specify one or more delimiters.

The input delimiter determines how the mapping reads the input data when you select the Start or End option as the scope.

Set the scope for the search operation.

You can set the following options:

Anywhere. Removes any instance of the value that occurs in the input field. Can remove multiple instances of the same value in a field.

Start. Removes any instance of the value that is not preceded by another value in the input field.

End. Removes any instance of the value that is not followed by another value in the input field.

Enter a string to search for and remove in the

Custom Strings

field.

The search operation is case-sensitive.

Add the string to the list of strings to search for.

Optionally, add one or more additional strings to the list.

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.

Heather Feist - August 12, 2024

Hello, Can you give an example of a Custom String?

Informatica Documentation Team - August 13, 2024

Hi Heather Feist,

Please refer to this page for examples: Step configuration. We'll update the documentation to make the examples more prominent.

Regards,

Informatica Documentation Team

Rename Saved Search

Table of Contents

Cleanse assets

Cleanse assets

Removing instances of one or more values that you specify

Removing instances of one or more values that you specify