MATCHING_DICTIONARY_FUZZY

Syntax

MATCHING_DICTIONARY_FUZZY(Text to check: <String>;Dictionary: <List>)

Description

Extracts all dictionary entries from a given text column using a fuzzy matching algorithm. 

Application Notes

• text must be from type string

• dictionary must be from type list

• according to the length of the list, we recommend to set the dictionary as a global variable for a long list

Example 1

MATCHING_DICTIONARY_FUZZY(#sample_text!Address;TOKENIZELIST(${Dictionary};','))

• the dictionary has been created as a global variable in the Admin section

• TOKENIZE function must be applied instead of the dictionary list

Example 2

MATCHING_DICTIONARY_FUZZY(#sample_text!Address;["UN","EN"])

• the dictionary is entered as a comma-separated list