Standardization Properties
To configure properties for standardization strategies and operations, select the Strategies view in the Standardizer transformation.
Strategy Properties
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.
Operation Properties
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.