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 to represent the type of column that contains the business data.
5. 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
6. Select the type of condition to apply to the input.
- - To compare the input data to a string value, select the following condition type:
null value
7. Select the type of action to apply to the data that satisfies the condition logic.
- - To standardize the data, select the following condition type:
function
8. Configure 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.
- - Click OK.
9. Save the rule specification.