Skip to content

Text Functions

Text functions allow you to manipulate and transform text values in your data.

Contains

Searches for specified substring(s) in a text value (case-sensitive). Returns True if found, False otherwise.

Case Sensitivity

This function is case-sensitive. "urgent" will not match "URGENT". Use Contains(Lower([column]), "urgent") for case-insensitive searches.

Category: text

Syntax:

Contains([string_column], "substring", |substring2|, ...)

Returns: BooleanColumn

Context Filtering: ✓ Yes

Parameters

Name Type Required Description
string_column column ✓ Yes A column to search for text values.
substring text ✓ Yes Substring to search for in the text value. Up to 5 substrings can be provided.

Allowed Column Types: STRING, TEXT

Validation

  • Minimum parameters: 2
  • Maximum parameters: 6

Examples

Contains([Product Name], "Digital Camera")

Searches for substring in each product name.

  • Upper - Convert to uppercase for standardization
  • Lower - Convert to lowercase for case-insensitive operations

Left

Returns a substring that begins at the start of a given string column values.

Category: text

Syntax:

Left([string_column], number)

Returns: StringColumn

Context Filtering: ✓ Yes

Parameters

Name Type Required Description
string_column column ✓ Yes The string column from which a left substring will be returned.
number number ✓ Yes The desired length of the returned substring. A negative number removes characters from the end.

Allowed Column Types: STRING, TEXT

Validation

  • Minimum parameters: 2
  • Maximum parameters: 2

Examples

Left([Address], 5)

Returns first 5 characters of each address.

  • Right - Extract from end of string
  • Upper - Convert extracted text to uppercase

Lower

Converts a given string to lowercase.

Category: text

Syntax:

Lower([text_column])

Returns: StringColumn

Context Filtering: ✓ Yes

Parameters

Name Type Required Description
text_column column ✓ Yes A text column.

Allowed Column Types: STRING, TEXT

Validation

  • Minimum parameters: 1
  • Maximum parameters: 1

Examples

Lower([Name])

Converts each name in the column to lowercase.

  • Upper - Convert to uppercase
  • Contains - Use with Lower for case-insensitive searches

Returns a substring from the end of a string column values. The last n characters where n is the number argument.

Category: text

Syntax:

Right([text_column], number)

Returns: StringColumn

Context Filtering: ✓ Yes

Parameters

Name Type Required Description
text_column column ✓ Yes The string column from which a right substring will be returned.
number number ✓ Yes The desired length of the returned substring.

Allowed Column Types: STRING, TEXT

Validation

  • Minimum parameters: 2
  • Maximum parameters: 2

Examples

Right([Phone], 4)

Returns last 4 digits of each phone number.

  • Left - Extract from start of string
  • Contains - Search for patterns in strings

Upper

Converts a given string to uppercase.

Category: text

Syntax:

Upper([text_column])

Returns: StringColumn

Context Filtering: ✓ Yes

Parameters

Name Type Required Description
text_column column ✓ Yes A text column.

Allowed Column Types: STRING, TEXT

Validation

  • Minimum parameters: 1
  • Maximum parameters: 1

Examples

Upper([Status])

Converts each status in the column to uppercase.

  • Lower - Convert to lowercase
  • Contains - Use with Upper for case-insensitive searches