User Tools

Site Tools


syntax:functions:contains

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

ArgumentTypeDescription
textTextThe text value to search within for the look_for string.
look_forTextThe 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') //Returns TRUE
contains('Mount Killimanjaro', 'Mountain') //Returns FALSE
contains('Mont Blanc', 'blanc') //Returns FALSE  (Non-matching cases.)
contains([Mtn_Name],'Everest') //Returns TRUE  (Using a field name; if [Mtn_Name] is 'Mount Everest')
contains([Mtn_Name], 'Everest') //Returns 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.txt · Last modified: 2021/08/14 21:59 by craigt