Differences

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

--- syntax:functions:contains [2015/04/03 10:45] – elenap
+++ syntax:functions:contains [2021/08/01 19:36] – 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 //textA// or a field //FieldName// contains specific text //textB//.
+\\
+=====Description=====
+This function determines whether //text// contains the //look_for// string.  If found, this function returns TRUE, otherwise it returns FALSE.
-True if the first text string //textA// contains the other text string //textB//. 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 |
-To use with a field, when FieldA = city:
+\\
+=====Remarks=====
+This function is case sensitive.
-^  Example  ^  FieldA  ^  Result  ^
+\\
-| contains([city], 'New') | New York |  TRUE  |
+=====Examples=====
-| contains([city], 'New') | Los Angeles |  FALSE  |
+  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:find]]
+\\
-  * [[syntax:functions:endswith]]
+===== See also =====
-  * [[syntax:functions:startswith]]
+  * [[syntax:functions:find]|Find(text, look_for)]]
+  * [[syntax:functions:endswith]|EndsWith(text1, look_for)]]
+  * [[syntax:functions:startswith]|StartsWith(text1, look_for)]]