This function replaces occurrences of the elements from a delimited list in a string with corresponding elements from another delimited list. The search is case insensitive.
ReplaceListNoCase(string, list1, list2,includeEmptyFields) ReplaceListNoCase(string, list1, list2, delimiter, includeEmptyFields) ReplaceListNoCase(string, list1, list2, delimiter_list1, delimiter_list2, includeEmptyFields)
Parameter | Description |
string | A string, or a variable that contains one, within which to replace substring. |
list1 | Comma-delimited list of substrings for which to search. |
list2 | Comma-delimited list of replacement substrings. |
delimiter | Common delimiter for both search and replacement. |
delimiter_list1 | Delimiter for search. |
delimiter_list2 | Delimiter for replacement. |
includeEmptyFields | When true, empty list elements are preserved. |