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:
- STRING input_list: A comma separated list of elements. Double quote delimiting of elements is supported
- STRING operator: that will be applied to identify a match. This must be one of EQUALS, NOTEQUALS, CONTAINS, NOTCONTAINS, STARTSWITH or ENDSWITH
- STRING search_list,: A comma separated list of elements. Double quote delimiting of elements is supported
- 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:
- MATCH_IN_LIST('apple, banana, cherry', 'EQUALS', 'cherry, pear', FALSE) = 'cherry'
- MATCH_IN_LIST('apple, banana, cherry, "peach"', 'EQUALS', 'cherry, pear, peach', TRUE) = '"cherry", "peach"'
- MATCH_IN_LIST('apple, banana, cherry, "peach"', 'NOTEQUALS', 'cherry, pear, peach', FALSE) = 'apple, banana'
- MATCH_IN_LIST('apple, banana, cherry, "peach"', 'CONTAINS', 'e', FALSE) = 'apple, cherry, peach'
- MATCH_IN_LIST('apple, banana, cherry, "peach"', 'NOTCONTAINS', 'e,h', FALSE) = 'banana'
Comments
0 comments
Please sign in to leave a comment.