Differences

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

--- syntax:functions:contains [2015/03/29 21:37] – 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'). Can be used in Transformation **Filter by condition** - see Example 3.
+\\
+=====Description=====
+This function determines whether //text// contains the //look_for// string.  If found, this function returns TRUE, otherwise it returns FALSE.
-True if 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 |
-| contains([City], 'York')     | (Table keeps filtered rows)|
+\\
+=====Remarks=====
+This function is case sensitive.
-=== See also ===
+\\
-  * [[syntax:functions:find]]
+=====Examples=====
-  * [[syntax:functions:endswith]]
-  * [[syntax:functions:startswith]]
+  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]|Find(text, look_for)]]
+  * [[syntax:functions:endswith]|EndsWith(text1, look_for)]]
+  * [[syntax:functions:startswith]|StartsWith(text1, look_for)]]