Using Masks - trillium_discovery - trillium_quality - 17.1

Trillium Control Center

Product type
Software
Portfolio
Verify
Product family
Trillium
Product
Trillium > Trillium Discovery
Trillium > Trillium Quality
Version
17.1
Language
English
Product name
Trillium Quality and Discovery
Title
Trillium Control Center
Topic type
Administration
Overview
How Do I
Configuration
Reference
Installation
First publish date
2008

Masks are character representations of a data value which define each character in the data value. The following mask files are used and located in: C:/Program Files/Trillium Software/MBSW/17/tsq/tables/general_resource.

  • maskfile.win/unx. The mask files used for most processes.
  • vcnmasks.win/unx. The mask files used by the Window Key Generator process (variations: grvcnmask, trvcnmask).
Note: The vcnmasks files include encoding specific entries such as Latin1, Latin2, Greek, and so on. See the actual files for details. grvcnmask and trvcnmask files are the same as vcnmasks and provided for backward compatibility with pre-V15 functionality.
  • ilmasks.win/unx. The mask files used by the Israeli (IL) project.
  • rumasks.win/unx. The mask files used by the Russian (RU) project.
  • zzmasks.win/unx. The mask files used by the Basic Country (ZZ) project.

The following is the sample default mask values used in the Quality component. See the actual mask files for details.

Mask Character

Default Value

Character Range Represented

ALPHA

A

Any letter (a-z, A-Z)

NUMERIC

N

Numeral (0-9) or the uppercase letter N

You may change either of these default mask characters and define additional mask characters for any of the following character ranges by modifying the mask files:

Mask Character

Value

Character Range Represented

VOWEL

User defined

Vowel

CONSONANT

User defined

Consonant

UPPER-CASE

User defined

Uppercase character

LOWER-CASE

User defined

Lowercase character

HEX-DIGIT

User defined

Hex value

MATH-SYMBOL

User defined

Math symbol

CURRENCY-SYMBOL

User defined

Currency Symbol

PUNCTUATION

User defined

Punctuation

USER-DEF-1~6

User defined

User defined.

There are six user-defined mask groups. See User Defined masks.

Explicit

 

Any data value element that is not mapped to a mask.

It is shown exactly as it appears in the data value, including spaces.

Note that the mask character represents itself literally as well as the characters within the character range. For example, '$' would be a good choice for CURRENCY-SYMBOL because it falls within the character range it represents. However 'D' would not be a good choice for CURRENCY-SYMBOL because it is not within the range of currency symbols.

Similarly, 'N' is used as a default mask value for the NUMERIC character range for backward compatibility with old versions of the product. However this can lead to ambiguous situations because 'N' also represents itself literally. This means a value like "JANE" will have two possible masks "AANA" or "AAAA" while "Jane" will have a mask of "AAAA." You can avoid this ambiguity by editing the mask file and changing the character used to represent NUMERIC to a value within the NUMERIC character range such as '9' (Unicode value U0039).

Value Mask Patten
JANE SMITH AANA AAAA or AAAA AAAA
5.00E+02 N.NNA+NN
$400.00 $NNN.NN
05/31/2005 NN/NN/NNNN
jane_smith@abc.com AAAA_AAAA@AAA.AAA
NULL NAAA or AAAA

To edit the mask files

  1. From the Navigation or Project View, right-click the Transformer process and select Edit Process. You can also double-click the process to open it for editing.
  2. Select the Advanced Rules tab. The path and name of the default mask file is displayed.
  3. Click Copy to client for the Mask Definitions file.
  4. Select a destination folder and click OK. The mask file will be copied to the folder you specified.
  5. Go to the folder and edit the file.

    Example

    The default file contains:

    NUMERIC

    * N - Default

    U004E (DEFAULT)

    If you want to use '9' , for example, as your mask value for numerics, change this entry to:

    NUMERIC

    *9 - Default

    U0039 (DEFAULT)

  6. Save the file and click Upload to upload the file back to the server.
  7. Click Finish.
    Note: Make sure to use the new mask values after editing the mask file. For example, you must specify '9' instead of 'N' in all of your attribute scans.