Eliminating redundant character spaces in advanced mode
To eliminate redundant spaces in a data set, write rule logic to replace multiple character spaces with a single space.
For example, you organization might decide to identify duplicate records in a data set. When you perform deduplication operation on your data set, the redundant spaces in the data values might lead to incorrect results. If you do not eliminate the redundant character spaces, the deduplication operation might not correctly identify the records that are identical as duplicates, which leads to duplicate entries in the data set.
1Open a rule specification in advanced mode.
2Verify that the rule specification contains the inputs and outputs that you require.
- If the rule specification does not contain an input and an output that you can use, create an input and output. Configure the input and output properties to represent the type of column that contains the business data.
3 In the rule editor, type the output name.
4Enter an operator value. For example, enter the = value to write a value for the data that satisfies the rule logic.
5To remove redundant characters, select the removeMultipleSpaces function in the operation.
You can select the function from the suggestion list.
6Type the name of an input that represents the column of data that the rule specification will search at run time.
The following example shows rule logic that contains a standardize operation: