Use this procedure to check the length of fields in the Customer Data table to determine the validity of a field in a customer record. For example, you can see which records contain the incorrect number of digits for the telephone number. When the table displays the search results , you can either correct the content of the field or delete the record.
Before you begin
Ensure that you have data in the Customer Data table.
Procedure
On the Oceana Customer Management Tool interface, click Import customer data.
On the Customer Settings tab, click Customer Data Search.
Click the Length Search tab.
In the Select Field field, click the column on which to search the length.
In the Operation box, click the mathematical operation that applies to your search:
Greater than
Equal to
Less than
In the Number of digits box, enter the number of digits that each entry in the column must contain.
If you want the length check to ignore spaces, select the Ignore Spaces check box.
To check the length on specific rows of the table, select the rows, and then click Selected Customers.
Click Search.
Customer data that matches your criteria is highlighted and moved to the top of the Customer Data table.
Do one of the following:
Change the data.
Delete the rows by clicking Delete Checked Customers.
