Build Custom Sample Criteria

Use this procedure to understand how to build custom sample criteria using regular expressions. The custom criteria tells the sampling utility about what patterns to look for in a column, enabling the identification of specialized forms of Personally Identifiable Information (PII).
tdm49
Use this procedure to understand how to build custom sample criteria using regular expressions. The custom criteria tells the sampling utility about what patterns to look for in a column, enabling the identification of specialized forms of Personally Identifiable Information (PII).
  1. Open the
    Sample Options
    dialog as mentioned in the Profile (or Sample) Your Data section.
  2. Click the
    Use Filters
    tab.
  3. Click the plus icon to create a new filter.
  4. Enter the filter name.
  5. Select
    Regular Expression
    from the drop-down list.
    The filter syntax corresponds to standard regular expressions.
    For example, add ^[0-9] in the
    Condition
    field after selecting the
    Regular Expression
    option. This example specifies that it must look for a number (specified by the character class [0-9]) at the beginning of a given string (CA TDM syntax uses the caret (^) character rather than the dollar ($) character). 
    The filter is added to the
    Filter Name
    list.
  6. To use the filter, select the created filter name.
    The new filter is added as a custom filter to the list of filters in the
    Transformation Maps
    dialog.