BUSNAME 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
Administration
Configuration
Installation
Reference
How Do I
First publish date
2008

The ALPHANUM modifier is used with the BUSNAME 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 100 (exact match).