SUBSTRNG With Modifier (AND) - 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

The AND modifier is used with the SUBSTRNG routine to take both comparisons into consideration. This routine requires two fields defined from each record: field 1 is the first field, field 2 is the second field. It performs two comparisons:

  1. Compares field 1 from record 1 with field 2 from record 2 and detects whether field 1 is an exact match of field 2.
  2. Compares field 1 from record 2 with field 2 from record 1 and detects whether field 1 is an exact match of field 2.

This routine returns a score by taking both comparisons into consideration.

Table 1. Scoring for the AND Modifier

Score

Description

100

First field is exactly the second field for both comparisons.

50

First field is exactly the second field for one comparison.

0

Any other value.

Example

Record Field 1 Field 2

1

John

John Paul
2

Jo

John

Score returned = 50 ('John" vs "John")