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'). Can be used in Transformation Filter by condition - see Example 3.
True if first text string ('textA') contains the other text string ('textB'). Case sensitive.
| Example | Result |
|---|---|
| contains( '2014/09/18', '/' ) | True |
| contains( 'Canada', 'CAN' ) | False |
| contains([City], 'York') | (Table keeps filtered rows) |
See also
syntax/functions/contains.1427679442.txt.gz · Last modified: 2015/03/29 21:37 by elenap