Developer Transformation Guide

Back Next

Standardization Properties

To configure properties for standardization strategies and operations, select the

Strategies

view in the Standardizer transformation.

Strategy properties apply to all the operations within a strategy. You can configure the following strategy properties:

Remove multiple spaces: Replaces multiple consecutive spaces with one space.
Remove trailing and leading spaces: Removes spaces from the beginning and end of data strings.
Delimiters: Determines the delimiters that define search tokens. For example, if you choose "Semicolon," the Standardizer transformation searches the string "oranges;apples;" and finds the strings "oranges" and "apples." The transformation uses the space delimiter by default.

You can configure properties for the following types of standardization operations.

Reference Table Operations: Reference table operations include the following properties:

Reference table
. Determines the reference table you use to standardize data. Click
Browse
to select a reference table.

Case Sensitive
. Determines whether input strings must match the case of reference table entries.

Replace With
. Replaces input strings that match reference table entries with the text you provide. Applies to replacement operations only.

Scope
. Specifies the part of the input string that contains the reference table value.
Custom String Operations: Custom string operations include the following properties:

Match Tokens With
. Defines the search strings to find within input data.

Replace With
. Replaces input strings that match the search strings you specify. Applies to replacement operations only.

Scope
. Specifies the part of the input string to search.