Syntax
LIKE(stringMATCHING_DICTIONARY(Text to check: <String>;patternDictionary: <String><List>)
Description
...
Allows case-sensitive matching of strings based on comparison with a pattern.
...
Extracts all dictionary entries from a given text column.
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(#sample_text!Address;TOKENIZELIST(${Dictionary};','))
the dictionary has been created as a global variable in the Admin section
/wiki/spaces/SUD10/pages/8815064748 function must be applied instead of the dictionary list
Address | MATCHING_DICTIONARY |
ABOT SQUARE CANARY WHARF LONDON UNI;TED KINGDOM | [AR, ARE, BO, CA, CAN, DO, DOM, GD, IN, KI, NA, NG, NI, OM, RE, UA] |
3RD FLOOR 301 BELLEVUE;PARKWAY WILMINGTON DELAWARE US 198;09 | [AR, ARE, AW, BE, BEL, DE, GT, IL, IN, KW, LA, NG, PA, RE, TO, TON, US, VU] |
CORPORATION LKG TOWER 6801 AYALA A;VENUE MAKATI CITY METRO MANILA PH | [AL, AT, CI, CO, ER, ET, IL, IO, IT, KG, LA, LK, MA, ME, NI, NU, PH, RO, TO, TR, VE, VEN] |
Example 2
MATCHING_DICTIONARY(#sample_text!Address;["UN","EN"])
the dictionary is entered as a comma-separated list
Address | MATCHING_DICTIONARY |
|---|---|
ABOT SQUARE CANARY WHARF LONDON UNI;TED KINGDOM | [UN] |
3RD FLOOR 301 BELLEVUE;PARKWAY WILMINGTON DELAWARE US 198;09 | [ ] |
CORPORATION LKG TOWER 6801 AYALA A;VENUE MAKATI CITY METRO MANILA PH | [EN] |