Differences

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

--- syntax:functions:contains [2015/04/03 10:45] – elenap
+++ syntax:functions:contains [2015/04/03 10:49] – dmitry
@@ 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//.
+A search function that is used to check if a string of text contains specific text.
-True if the first text string //textA// contains the other text string //textB//. Case sensitive.
+It returns TRUE if //textA// contains the other text string //textB//, otherwise it returns FALSE. This function is case sensitive.
 ^  Example  ^  Result  ^
@@ Line 9: / Line 9: @@
 | contains( 'Canada', 'CAN' )  |  FALSE |
-To use with a field, when FieldA = city:
+Examples using a field name:
-^  Example  ^  FieldA  ^  Result  ^
+^  Example  ^  City  ^  Result  ^
-| contains([city], 'New') | New York |  TRUE  |
+| contains([City], 'New') | New York |  TRUE  |
-| contains([city], 'New') | Los Angeles |  FALSE  |
+| contains([City], 'New') | Los Angeles |  FALSE  |