View the original community article here
Last tested: Mar 31, 2021
You may run into a situation where you need to search for a string inside of a table calculation or a custom field, which means that you need to use a contains() function to determine if a string is present in another field. But what if you have multiple entries in a field and they might be capitalized differently? Easy! We can use the following formula:
contains(lower(${my_string_dimension}),"thing i'm searching for in lower case")
This content is subject to limited support.