The contains function can produce a TRUE or FALSE outcome, if the substring which the user defines is contained in the string. It can be used to gather specific items dependant on an attribute or property value. This function is CASE SENSITIVE.
Syntax
CONTAINS(x,y)
Parameters
x = The string in which you want to search for the sub-string
y = The substring, which the string will be searched for
Type of Data Returned
Boolean or Text*
*Will only return a text value if you set two labels up as “TRUE” and “FALSE”. Useful to be able to use them for filtering purposes.Examples
CONTAINS(“SharpCloud Calculated Value”, “Calc”) will return TRUE
CONTAINS(“SharpCloud Calculated Value”, “CALC”) will return FALSE as the function is case sensitive.
Using the CONTAINS function to return any items that have an owner name of “Tim S”
CONTAINS(“Owner”,”Tim S”) will return items as TRUE if they contain “Tim S” within their owner string, the rest of the items will be FALSE.
Using CONTAINS in terms of an array and values to determine a true and false outcome
CONTAINS(“LowMedHi”, “Med") will return a value of TRUE.