Improving the Usability of Business Data
To improve the usability of data values, you can delete character spaces at the start and the end of a data field. The redundant spaces introduce errors when you sort or compare data values that contain the same information.
Configure a rule statement that deletes the redundant spaces. If you want to specify longer character strings, create a rule statement that uses the "Replace Character" function.
1. Select a rule set in a rule specification.
2. In the rule set properties, click Rule Logic.
3. Click Add Rule Statement.
4. Select an input for the rule statement.
- - If the rule set does not contain an input, create an input. Configure the input properties represent the type of column that contains the business data.
5. Configure the condition.
- - Click the condition icon to open the Define Condition dialog box.
- - Select Functions.
- - Select the Null function.
- - Select the rule statement input.
- - Click OK.
6. Select 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
7. Configure the action to remove the redundant spaces from the input data.
- - Click the action icon to open the Define Action dialog box.
- - Select Standardize, and select Remove Leading and Trailing Spaces.
- - Select the input that you specified in the condition.
- - Click OK.
8. Save the rule specification.