Differences

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

--- syntax:functions:contains [2015/03/29 21:37] – elenap
+++ syntax:functions:contains [2015/04/03 10:25] – elenap
@@ Line 1: / Line 1: @@
 ====== Contains(textA, textB) ======
-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.
+A search function that is used to check if a string of text (//textA//) or a field (//FieldName//) contains specific text (//textB//).
-True if first text string ('textA') contains the other text string ('textB'). Case sensitive.
+True if the first text string (//textA//) contains the other text string (//textB//). Case sensitive.
 ^  Example  ^  Result  ^
-| contains( '2014/09/18', '/' )  |  True |
+| contains( '2014/09/18', '/' )  |  TRUE |
-| contains( 'Canada', 'CAN' )  |  False |
+| contains( 'Canada', 'CAN' )  |  FALSE |
-| contains([City], 'York')     | (Table keeps filtered rows)|
+To use with a field (i.e. column), when FieldA = city:
+^  Example  ^  FieldA  ^  Result  ^
+| contains([city], 'New') | New York |  TRUE  |
+| contains([city], 'New') | Los Angeles |  FALSE  |