MATCHING_DICTIONARY
- Juliane Wetzel
Syntax
MATCHING_DICTIONARY(Text to check: <String>;Dictionary: <List>)
Description
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
TOKENIZE 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] |