MATCH_IN_LIST Function

Parameters (String input_list,  String operator, String search_list, Boolean delimit_values);

Returns: String;

This function checks all elements in an input list (comma separated) with those in the search list. Only elements in in the input_list that match a search_list element are included in the returned comma separated list. The matching is case insensitive.

Parameter Descriptions:      

1. STRING input_list: A comma separated list of elements. Double quote delimiting of elements is supported
2. STRING operator: that will be applied to identify a match. This must be one of EQUALS, NOTEQUALS, CONTAINS, NOTCONTAINS, STARTSWITH or ENDSWITH
3. STRING search_list,: A comma separated list of elements. Double quote delimiting of elements is supported
4. BOOLEAN delimit_values: defines whether the elements in the returned list will be double quote delimited and must be TRUE or FALSE

Notes on Use:

• If the input_list or search_list is NULL, NULL will be returned.
• If the operator is NULL, or not one of the recognised values, an error will be thrown.
• If the delimit_values parameter is not TRUE or FALSE, an error will be thrown.
• All leading or trailing whitespace in list elements is trimmed before matching.

Examples:             

1. MATCH_IN_LIST('apple, banana, cherry', 'EQUALS', 'cherry, pear', FALSE) = 'cherry'
2. MATCH_IN_LIST('apple, banana, cherry, "peach"',  'EQUALS', 'cherry, pear, peach', TRUE) = '"cherry", "peach"'
3. MATCH_IN_LIST('apple, banana, cherry, "peach"', 'NOTEQUALS', 'cherry, pear, peach', FALSE) = 'apple, banana'
4. MATCH_IN_LIST('apple, banana, cherry, "peach"', 'CONTAINS', 'e', FALSE) = 'apple, cherry, peach'
5. MATCH_IN_LIST('apple, banana, cherry, "peach"', 'NOTCONTAINS', 'e,h', FALSE) = 'banana'