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.

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)

This function is case sensitive.

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.