syntax:functions:contains
This is an old revision of the document!
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).
True if the first text string (textA) contains the other text string (textB). Case sensitive.
| Example | Result |
|---|---|
| contains( '2014/09/18', '/' ) | TRUE |
| contains( 'Canada', 'CAN' ) | FALSE |
To use with a field, when FieldA = city:
| Example | FieldA | Result |
|---|---|---|
| contains([city], 'New') | New York | TRUE |
| contains([city], 'New') | Los Angeles | FALSE |
See also
syntax/functions/contains.1428072077.txt.gz · Last modified: 2015/04/03 10:41 by elenap