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')  =()