Scan and Change Example - 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

This example illustrates scanning an entity for a literal value and changing it. In this example, the phone number currently has dashes and spaces. To match more accurately, you can remove the dashes and spaces from the phone number. To scan and change the phone number format, use the following arguments:

Scan Field Phone Number
Field Justification LP (Left Pack)
Scan Value - (a dash)
Scan Function CH
Change Value ""(two sets of double quotes)
Change Occurrences A (for All)

The settings would look like these in the Field Scan section window:

These settings will cause the Transformer to left-pack the value in Phone Number and scan for the literal value "-" at the Field level. If the value is found, the Transformer will change the value to nothing.