Differences

This shows you the differences between two versions of the page.

--- syntax:functions:contains [2015/04/03 10:49] – dmitry
+++ syntax:functions:contains [2021/08/14 21:59] (current) – [Examples] craigt
@@ Line 1: / Line 1: @@
-====== Contains(textA, textB) ======
+====== Contains(text, look_for) ======
+Category:  Text function
-A search function that is used to check if a string of text contains specific text.
+\\
+=====Description=====
+This function determines whether //text// contains the //look_for// string.  If found, this function returns TRUE, otherwise it returns FALSE.
-It returns TRUE if //textA// contains the other text string //textB//, otherwise it returns FALSE. This function is case sensitive.
+\\
+=====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//.|
-^  Example  ^  Result  ^
+**Return value type:** Boolean (TRUE/FALSE)
-| contains( '2014/09/18', '/' )  |  TRUE |
-| contains( 'Canada', 'CAN' )  |  FALSE |
-Examples using a field name:
+\\
+=====Remarks=====
+This function is case sensitive.
-^  Example  ^  City  ^  Result  ^
+\\
-| contains([City], 'New') | New York |  TRUE  |
+=====Examples=====
-| contains([City], 'New') | Los Angeles |  FALSE  |
+  contains('Mount St. Helens', 'Mount') //Returns TRUE
-=== See also ===
+  contains('Mount Killimanjaro', 'Mountain') //Returns FALSE
-  * [[syntax:functions:find]]
-  * [[syntax:functions:endswith]]
+  contains('Mont Blanc', 'blanc') //Returns FALSE  (Non-matching cases.)
-  * [[syntax:functions:startswith]]
+  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)]]