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

The UC modifier is used with the SUBSTRNG routine to detect the presence of one string of characters (field 1) within another string of characters (field 2) and perform matching. This routine requires one field defined from each record.

This routine compares field 1 from record 1 with field 1 from record 2 and detests whether field 1 from record 1 is a substring of field 1 from record 2. The score varies depending on the location of substring.

Table 1. Scoring for SUBSTRNG (Modifier = UC)

Score

Description

100

First string is exactly the second string.

99

First string resides at the beginning or end of the second string.

98

First string resides within the second string.

97

Both strings are blank.

96

Only one string is blank.

0

Any other value.

Example

Record Field 1

1

Jo

2

John

Score returned = 99 ("Jo" resides at the beginning of "John")

Note: If there are spaces (full-width/half-width) in the middle of the field or before/after the field, the spaces will be ignored and only the text will be compared.