Rule Specification Guide

10.2.1
- 10.5.9
- 10.5.6
- 10.5.4
- 10.5
- 10.4.0
- 10.2.2

Back Next

Improving the Usability of Business Data

To improve the usability of data values, you can delete character spaces at the start and at 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. To delete longer character strings, create a rule statement that uses the "Replace Character" function.

Select a rule set in a rule specification.

In the rule set properties, click

Rule Logic

Click

Add Rule Statement

Select 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.

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

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

Select the type of action to apply to the data that satisfies the condition logic.

To standardize the data, select the following action type:

function

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

Save the rule specification.

Common Types of Rule Statements

Download Guide

Watch

Comments

Communities

Knowledge Base

Success Portal

0 COMMENTS

We’d like to hear from you! Log in to comment.

Rename Saved Search

Table of Contents

Rule Specification Guide

Rule Specification Guide

Improving the Usability of Business Data

Improving the Usability of Business Data