CONTAINS

Check if a string contains a substring

Description

Returns true if the given string contains the given substring, otherwise returns false.

Function signature

CONTAINS(string: String, pattern: String) => Boolean

Parameter

Description

String

String to test

Pattern

Substring to find

Examples

Formula

Return value

CONTAINS("Foo Bar", "Foo")

true

CONTAINS("Foo Bar", "foo")

false

CONTAINS("Foo Bar", "o B")

true