1. Oracle® Enterprise Data Quality Product Data Services User Guide
  2. Data Preparation
  3. Standardize Product Data
  4. Standardize The Product Description

Standardize The Product Description

This consists of:

  • Stripping diacritic characters.

  • Standardizing accented characters – (é to e for example).

  • Upper casing.

  • Replacing characters with spaces and/or stripping characters. The reference data used by this is Match Preparation – Product Description Character Strip/Standardize, by default it strips most non alpha-numeric characters, and replaces brackets and commas with spaces.

  • Standardizes the product description using a replace processor. This uses the Match Preparation – Product Description Standardize reference data to replace certain tokens or phrases with others. The provided reference data is empty, and it is likely that a customer will want to add their own entries to it. For example, if the data contains descriptions with the color “WHITE” represented in some places as “WHT”, they could replace “WHT” with “WHITE”.

  • Normalize the whitespace in the product description.

The result of this is the productdescriptionstandardized field.