contains

To check if a given string contains the exact given match

This function helps you to check if a given string of any length contains the exact match you are looking for. This is case-sensitive, so you might use upper() or lower() to format your text first. 
The result is true (Yes) for an exact match or false (No) for no exact match found.
Use this function to search for keywords in text fields, or if in a multiple-choice field, a specific option was selected. 
In case you are not only searching for a specific string but also need its position, you might want to use the index() function. 
Syntax
contains(string, string)
Return 
boolean 
Examples 
contains(myText, match) To check if a given string contains the exact given match.
1
contains("Hello world!", "Hello") 
Result: Yes (true)
​
1
contains("Hello world!", "hello")
Result: No (false)
​
1
contains(lower("Hello world!"), "hello")
Result: Yes (true)
See also 
​index, which returns the first position of appearance of the match in the string.

concat

cos

Last modified 8mo ago