STREETS With Modifier (ALPHANUM) - 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
Overview
Installation
How Do I
Configuration
Administration
Reference
First publish date
2008

The ALPHANUM modifier is used with the STREETS routine to cause the routine to replace all non-alpha and non-numeric characters with a blank character in each field prior to comparison.

For example, the following special characters are replaced with blank:

. period
, comma
' single quote
" double quote
- hyphen, dash
# number sign
+ plus sign
( left parenthesis
) right parenthesis
: colon
; semicolon

Example

Field 1: K-MART

Filed 2: K MART

Field 1 will be modified to "K MART" by replacing the "-" character with a blank character prior to comparison. Therefore, this example will return the score of 98.