The Standardization options contain several properties that you can configure to remove or replace data.
You can configure the properties to perform the following actions:
Remove Values
Searches an input field for one or more values that you specify, and removes the values.
You can enter one or more values that the asset will remove. Or, you can use a dictionary to identify the values that the asset will remove.
Remove Spaces
Removes redundant character spaces from an input field.
You can remove leading and trailing spaces, and you can replace multiple spaces with a single space.
Replace Values
Searches an input field for one or more values that you specify, and replaces the values. You can find and replace values in the following ways:
Enter one or more values that the asset can search for. Enter a single replacement value for every value that the asset finds.
Use a dictionary to identify multiple strings that the asset can search for. Use the same dictionary to specify a replacement value for each value that the asset finds.
Use a dictionary to identify multiple strings that the asset can search for. Enter a single replacement value for every value that the asset finds.
When you select a dictionary in an option, you must specify the column in the dictionary that
contains the valid values. You must also confirm one or more delimiters for the data
values that the action reads.
You
can select a dictionary that you create in
Data Quality
or in
Reference 360
. In basic mode, you can preview the content of a dictionary
that you create in
Data Quality
. You can't see a
preview of the
Reference 360
dictionary
columns. To view the dictionary data, go to
ASK INFAPreview
