====== 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') //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:find]|Find(text, look_for)]] * [[syntax:functions:endswith]|EndsWith(text1, look_for)]] * [[syntax:functions:startswith]|StartsWith(text1, look_for)]]