To improve the usability of data values, you can delete character spaces at the start and at the end of the values. The redundant spaces might introduce errors when you sort or compare the values.
Configure a rule statement that deletes the redundant spaces. To delete longer character strings, create a rule statement that uses the "Replace Character" function.
1Select a rule set in a rule specification.
2In the rule set properties, click Rule Logic.
3Click Add Rule Statement.
4Select an input for the rule statement.
- If the rule specification does not contain an input that you can use, create an input. Configure the input properties to represent the type of column that contains the business data.
5Select an operator to validate the results of the condition analysis.
- To specify that the condition does not apply to null data, select the following operator:
is not
6 Select the type of condition to apply to the input.
- To verify that the input values are not null, select the following condition type:
null value
7Select the type of action to apply to the data that satisfies the condition logic.
- To standardize the data, select the following action type:
function
8Configure the action to remove the redundant spaces from the input data.
- Open the Define Action dialog box.
- Select Standardize, and select Remove Leading and Trailing Spaces.
- Select the input that you specified in the condition.