syntax:functions:contains
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revision | Next revisionBoth sides next revision | ||
syntax:functions:contains [2015/03/29 21:37] – elenap | syntax:functions:contains [2015/04/03 10:25] – elenap | ||
---|---|---|---|
Line 1: | Line 1: | ||
====== Contains(textA, | ====== Contains(textA, | ||
- | A search function that is used to check if a string of text (' | + | A search function that is used to check if a string of text (//textA//) or a field (//FieldName//) contains specific text (//textB//). |
- | True if first text string ('textA') contains the other text string ('textB'). Case sensitive. | + | True if the first text string (//textA//) contains the other text string (//textB//). Case sensitive. |
^ Example | ^ Example | ||
- | | contains( ' | + | | contains( ' |
- | | contains( ' | + | | contains( ' |
- | | contains([City], 'York' | + | |
+ | To use with a table field (i.e. column), when FieldA = city: | ||
+ | |||
+ | ^ Example | ||
+ | | contains([city], 'New') | New York | TRUE | | ||
+ | | contains([city], ' | ||
syntax/functions/contains.txt · Last modified: 2021/08/14 21:59 by craigt