Adding Mask Definitions - trillium_quality - trillium_discovery - Latest

Trillium Control Center

Product type
Software
Portfolio
Verify
Product family
Trilliumâ„¢ software
Product
Trilliumâ„¢ software > Trilliumâ„¢ Discovery
Version
Latest
ft:locale
en-US
Product name
Trillium Quality and Discovery
ft:title
Trillium Control Center
Copyright
2025
First publish date
2008
ft:lastEdition
2025-08-28
ft:lastPublication
2025-08-28T06:18:28.409000
L1_Product_Gateway
Verify
L2_Product_Segment
Data Quality
L3_Product_Brand
Precisely Trillium
L4_Investment_Segment
Core Data Quality
L5_Product_Group
Data Quality - Application
L6_Product_Name
Trillium Discovery

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.