Checking for a value

Last Updated : Jun 27, 2018 |

About this task

Use this procedure to check for fields that contain a specific value in your Customer Data table to ensure that the records are all valid. For example, you can search for records where the telephone numbers are not in your local area.

Before you begin

Ensure that you have data in the Customer Data table.

Procedure

  1. On the Oceana Customer Management Tool interface, click Import customer data.
  2. On the Customer Settings page, click Customer Data Search.
  3. Click the Value Search tab.
  4. In the Select Field list, click the column on which to do the value search.
  5. In the Operation field, click the mathematical operation that applies to your value search:
    • Equal to

    • Not equal to

    • Contains

    • Does not contain

  6. In the Select Value field, type the information that corresponds to the operation and selected field.
  7. To check the value on specific rows of the table, select the rows, and then click Selected Customers.
  8. Click Search.

    The Customer Data table displays the customer data that match your on the top.

  9. Do one of the following:
    • Change the data.

    • Delete the rows by clicking Delete Checked Customers.