syntax:functions:contains
This is an old revision of the document!
Table of Contents
Contains(text, look_for)
Category: Text function
Description
This function determines whether text contains the look_for string. If found, this function returns TRUE, otherwise it returns FALSE.
Arguments
| Argument | Type | Description |
|---|---|---|
| text | Text | The text value to search within for the look_for string. |
| look_for | Text | The text string to search for within text. |
Return value type: Boolean (TRUE/FALSE)
Remarks
This function is case sensitive.
Examples
contains('Mount St. Helens', 'Mount') = TRUE
contains('Mount Killimanjaro', 'Mountain') = FALSE
contains('Mont Blanc', 'blanc') = FALSE //Non-matching cases.
contains([Mtn_Name],'Everest') = TRUE //Using a field name; if [Mtn_Name] is 'Mount Everest'
contains([Mtn_Name], 'Everest') = FALSE //Using a field name; if [Mtn_Name] is 'K2'
For "per row" matching between two columns, field names can be used for both text and look_for.
See also
syntax/functions/contains.1627860987.txt.gz · Last modified: 2021/08/01 19:36 by craigt