User Tools

Site Tools


syntax:functions:contains

Differences

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

Link to this comparison view

Both sides previous revision Previous revision
syntax:functions:contains [2015/04/03 14:45]
elenap
syntax:functions:contains [2015/04/03 14:49] (current)
dmitry
Line 1: Line 1:
 ====== Contains(textA, textB) ====== ====== 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 FALSEThis function is case sensitive. 
  
 ^  Example  ^  Result  ^ ^  Example  ^  Result  ^
Line 9: Line 9:
 | contains( 'Canada', 'CAN' )  |  FALSE | | 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  | 
  
  
syntax/functions/contains.txt · Last modified: 2015/04/03 14:49 by dmitry