Use this procedure to check the fields for particular alphabetic characters or symbols to correct the data or delete the entire record from the Customer Data table.
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 page, click Customer Data Search.
Click the Numeric Search tab.
In the Select Field list, click the column on which to check for alphabetic characters.
To check the alphabetic character on specific rows of the table, select the rows, and then click Selected Customers.
Click Search.
Rows that include non-numeric characters in the selected column are highlighted and moved to the top of the table.
Do one of the following:
Change the data.
Delete the rows by clicking Delete Checked Customers.