Adding Mask Definitions - trillium_discovery - trillium_quality - Latest

Trillium Control Center

Product type
Software
Portfolio
Verify
Product family
Trillium
Product
Trillium > Trillium Discovery
Version
Latest
Language
English
Product name
Trillium Quality and Discovery
Title
Trillium Control Center
Copyright
2024
First publish date
2008
Last updated
2024-10-18
Published on
2024-10-18T15:02:04.502478

Masks describe the shape of a data value based on a pattern of alphabetic and numeric characters. You use the Mask Definitions Tool to add mask-phrase definitions and associate them with categories in much the same way you add word and phrase definitions in the Word Definitions Tool (although the synonym and multiple phrase options do not apply to mask definitions).

Defining masks can save the time of creating word definitions for certain values; for example defining masks for dates would be faster than defining every date value that may occur in your data.

Use masks to discover:

  • Misspellings
  • Typing errors and other inconsistencies that determine whether or not the mask pattern(s) is correct

Masks consist of:

a alphabetic characters
n numbers
specialchar

Characters other than letters or numbers, including punctuation marks, are represented by the characteritself; for example @, &, %, /.

Example

Say you have product codes for which you want to create a mask. The mask would allow you to identify irregularities in your source data by verifying the codes that conform to the mask shape; for example, a product code of ZZ1234 would have a mask of aannnn. Masks can also be recoded to standardize the data. A possible recode of aannnn is aa-nnnn.

Note: Recode values can include any alphanumeric characters, either uppercase or lowercase.
Note: You cannot use single quotes (' ') in the Mask Definitions Tool.

To add mask definitions

  1. From the Navigation or Quality Project View, right-click the Business Data Parser process and select Edit Process. The BDP editing window opens.
  2. Click Tools > Mask Definitions. The Mask Definitions window displays.
  3. In the Mask-phrases column, enter a mask value.
  4. In the Category column, select a category from the drop-down list. This list is populated with the categories you added in the Word Definitions Tool.
  5. Select a position and add a recode and a classification, as needed.
  6. Click OK.
  7. Click Launch Parser Tuner... to open the Parser Tuner and verify your definitions in the Customized Definitions table.