String comparisons

Back to: Index of transforms

Transforms in this section compare string data types. These comparison transforms are useful for filtering transform table rows by string columns. These comparison transforms can also be used separately outside of transform tables. Learn more about how to search for and add a transformation.

• Starts with
• Ends with
• Contains
• Does not contain
• Is (String)
• Is not (String)

Starts with

Returns True if the input string starts with the specified substring (case-sensitive). Treats special characters such as . / @ a - and spaces as part of the literal search string, as oppose to the "contains" transform which uses special characters as word boundaries.

Ends with

Returns True if the input string ends with the specified substring (case-sensitive).

Contains

Returns True if the input string contains the specified substring (case-sensitive). Treats special characters such as . / @ a - and spaces as word boundaries.

Does not contain

Returns True if the input string does not contain the specified substring (case-sensitive).

Is (String)

Returns True if input values are the same (case-sensitive).

Is not (String)

Returns True if input values are different (case-sensitive).