Supporting File Structures|FindDuplicateRecords Match Aliases Files
Match Aliases Files are used to alias data conversion and matching functions, such that a set of one or more conversion and matching functions can
be grouped under a single alias name.
This makes longer series of conversion and matching functions, convenient to refer to by a single function name.
A typical FindDuplicateRecords Matching Aliases File would look like this (abbreviated) :-
# DuplicateRecords - Match Function Aliases.
#
# Match function aliases are convenient forms of one or more other function names.
# Alias names should be directly related to the column type they are principally
# designed to operate on. Each alias should reference at least one column
# matching function. One alias cannot reference another. A maximum of 256
# different aliases are allowed.
#
# The format of this file should be :-
#
# ALIAS_NAME() [conversion_functions, ...] single_matching_function.
#
# For example ...
#
# ALIAS_SURNAME() REMOVE_NON_ALPHAS() EQUIVALENTS_FILE_WE('EquivalentsFiles/PersonNames_English.txt') =()
#
# ... where
# SURNAME() is the alias for
# REMOVE_NON_ALPHAS() EQUIVALENTS_FILE_WE('EquivalentsFiles/PersonNames_English.txt') =()
#
# All match function alias names must end with (). All other function names and any parameters
# present are match function aliases verbatim. Match function alias names including the () can be up to 32 characters long.
#
# This file can be amended.
#
ALIAS_SURNAME() REMOVE_NON_ALPHAS() EQUIVALENTS_FILE('EquivalentsFiles/PersonNames_English.txt') =()
ALIAS_SURNAME_FUZZY() REMOVE_NON_ALPHAS() EQUIVALENTS_FILE('EquivalentsFiles/PersonNames_English.txt') DAMERAU_MATCH_1()
ALIAS_FORENAME() REMOVE_NON_ALPHAS() EQUIVALENTS_FILE('EquivalentsFiles/PersonNames_English.txt') =()
ALIAS_FORENAME_FUZZY() REMOVE_NON_ALPHAS() EQUIVALENTS_FILE('EquivalentsFiles/PersonNames_English.txt') DAMERAU_MATCH_1()
ALIAS_GENDER() REMOVE_NON_ALPHAS() EQUIVALENTS_FILE('EquivalentsFiles/Genders_English.txt') =()
ALIAS_DATE() REMOVE_WHITESPACE() =()
ALIAS_DATE_FUZZY() REMOVE_WHITESPACE() DAMERAU_MATCH_1()
ALIAS_FLAT_NUMBER() REMOVE_WHITESPACE() EQUIVALENTS_FILE('EquivalentsFiles/Addresses_English.txt') =()
ALIAS_PREMISES_NUMBER() REMOVE_WHITESPACE() =()
ALIAS_HOUSE_NAME() REMOVE_ADDITIONAL_WHITESPACE() =()
ALIAS_HOUSE_NAME_FUZZY() REMOVE_ADDITIONAL_WHITESPACE() DAMERAU_MATCH_1()
ALIAS_STREET_NAME() REMOVE_ADDITIONAL_WHITESPACE() EQUIVALENTS_FILE('EquivalentsFiles/Addresses_English.txt') =()
ALIAS_STREET_NAME_FUZZY() REMOVE_ADDITIONAL_WHITESPACE() EQUIVALENTS_FILE('EquivalentsFiles/Addresses_English.txt') DAMERAU_MATCH_1()
ALIAS_CITY_NAME() REMOVE_NON_ALPHAS() =()
ALIAS_CITY_NAME_FUZZY() REMOVE_NON_ALPHAS() DAMERAU_MATCH_1()
ALIAS_COUNTY_NAME() EQUIVALENTS_FILE('EquivalentsFiles/Addresses_English.txt') REMOVE_NON_ALPHAS() =()
ALIAS_COUNTY_NAME_FUZZY() EQUIVALENTS_FILE('EquivalentsFiles/Addresses_English.txt') REMOVE_NON_ALPHAS() DAMERAU_MATCH_1()
ALIAS_COUNTRY_NAME() EQUIVALENTS_FILE('EquivalentsFiles/Addresses_English.txt') REMOVE_NON_ALPHAS() =()
ALIAS_COUNTRY_NAME_FUZZY() EQUIVALENTS_FILE('EquivalentsFiles/Addresses_English.txt') REMOVE_NON_ALPHAS() DAMERAU_MATCH_1()
ALIAS_POST_CODE() REMOVE_NON_ALPHA_NUMERICS() =()
ALIAS_ADDRESS() REMOVE_ADDITIONAL_WHITESPACE() EQUIVALENTS_FILE('EquivalentsFiles/Addresses_English.txt') =()
ALIAS_ADDRESS_FUZZY() REMOVE_ADDITIONAL_WHITESPACE() EQUIVALENTS_FILE('EquivalentsFiles/Addresses_English.txt') DAMERAU_MATCH_1()
ALIAS_TELEPHONE_NO() REMOVE_NON_NUMERICS() =()
ALIAS_TELEPHONE_NO_FUZZY() REMOVE_NON_NUMERICS() DAMERAU_MATCH_1()
ALIAS_WEB_WWW() REMOVE_NON_ALPHA_NUMERICS() =()
ALIAS_VEH_REG_NO() REMOVE_NON_ALPHA_NUMERICS() =()
ALIAS_VEH_REG_NO_FUZZY() REMOVE_NON_ALPHA_NUMERICS() LEVENSCHTEIN_MATCH_1()
ALIAS_COMPANY_NAME() REMOVE_ADDITIONAL_WHITESPACE() EQUIVALENTS_FILE('EquivalentsFiles/CompanyNames_English.txt') =()
ALIAS_COMPANY_NAME_FUZZY() REMOVE_ADDITIONAL_WHITESPACE() EQUIVALENTS_FILE('EquivalentsFiles/CompanyNames_English.txt') DAMERAU_MATCH_1()
ALIAS_TRUE_FALSE() REMOVE_ADDITIONAL_WHITESPACE() EQUIVALENTS_FILE('EquivalentsFiles/Booleans_English.txt') =()