Knowledge Drop

Methods for case insensitive string searches

  • 7 July 2021
  • 0 replies

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.                



0 replies

Be the first to reply!