Text formulas
Several functions help you process texts: contains, startsWith, and endsWith. They have the same syntax: contains({text}, {substring}) and return either TRUE or FALSE. Regexp is not supported. Operations are case-insensitive.
If any arguments are not strings, they are converted to strings:
- Any numbers are converted to strings.
- Booleans are converted to 1 or 0.
undefinedis converted to an empty string.
Example usages are provided below:
| Formula | Result | |
|---|---|---|
startsWith("foobar", "foo") | TRUE | |
startsWith("foobar", "") | TRUE | |
startsWith("foobar", toDateTime(" 2023-13-01 10:45:49")) | TRUE (because undefined was converted into an empty string) | |
endsWith("foobar", "bar") | TRUE | |
contains("foobar", "bar") | TRUE | |
contains("foobar", "BAR") | TRUE (because comparisons are case-insensitive) | |
contains("bar", "foobar") | FALSE |