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 revisionPrevious revision
Next revisionBoth sides next revision
syntax:functions:contains [2015/03/20 21:12] elenapsyntax:functions:contains [2015/03/20 21:31] elenap
Line 1: Line 1:
 ====== Contains(textA, textB) ====== ====== Contains(textA, textB) ======
  
-A search function that is used in Transformation **Filter by condition** 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 ('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. +True, if first text string ('textA') contains the other text string ('textB'). Case sensitive. 
  
 ^  Example  ^  Result  ^ ^  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)|
  
 === See also === === See also ===
syntax/functions/contains.txt · Last modified: 2021/08/14 21:59 by craigt

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki