Syntax
LIKE(stringMATCHING_DICTIONARY_FUZZY(Text to check: <String>;patternDictionary: <String><List>)
Description
Allows case-sensitive matching of strings based on comparison with a pattern.
Examples 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
Address | MATCHING_DICTIONARY |
ABOT SQUARE CANARY WHARF LONDON UNI;TED KINGDOM | [UNITED KINGDOM] |
3RD FLOOR 301 BELLEVUE;PARKWAY WILMINGTON DELAWARE US 198;09 | [US] |
12 MANOR GARDENS LA VRANGUE;ST PETERS PORT GUERNSEY GY1 2EZ;0731246591 | [ST, LA, GUERNSEY] |
Example 2
MATCHING_DICTIONARY_FUZZY(#sample_text!Address;["UN","EN"])
the dictionary is entered as a comma-separated list
Address | MATCHING_DICTIONARY |
---|---|
ORT KHALID P.O.BOX 21327 SHARJAH UN;ITED ARAB EMIRATES/AE | [UN] |
3RD FLOOR 301 BELLEVUE;PARKWAY WILMINGTON DELAWARE US 198;09 | [ ] |