Skip to main content
CONTAINS

Checks if text contains specified subtext.

Updated over 2 weeks ago

Description

The CONTAINS() function determines whether a specified subtext exists within a given text. It returns a boolean value: true if the subtext is found, and false otherwise. This is useful for filtering, searching, or validating data.

Syntax

CONTAINS(text, subtext)

Output

boolean

Variables

  1. text: The input text that you want to search for a subtext.

  2. subtext: The text you want to check for within the input text.

Example

CONTAINS(Label, 'World')

ID

Label

CONTAINS

1

Hello, World!

true

2

Example Text

false

3

Savant Analytics

false

4

Welcome to my World!

true

Did this answer your question?