Methods for case insensitive string searches

[iqbal_sandhu]

Knowledge Drop

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.