Wiki

Clone wiki

OYSTER / SOUNDEX

As a DataPrep function, SOUNDEX returns the SOUNDEX code of the attribute value as generated by the standard SOUNDEX algorithm. This function is not case sensitive. Example: the string "PATTERSON" generates the code "P362" As an Index function, SOUNDEX inserts the SOUNDEX code of the attribute value as an index key for the input record into the OYSTER Inverted Index. This function is not case sensitive. If either or both strings are empty or blank, the comparator returns False. Example: the string "PATTERSON" indexes the input record by the code "P362" As a Similarity Function, SOUNDEX returns true if the strings are non-empty and generate the same SOUNDEX code. This function is not case sensitive. Example: "PATTERSON" compared to "Peterson" returns True because both strings generate the SOUNDEX code P362.

Updated