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
syntax:functions:contains [2021/08/01 19:36] craigtsyntax:functions:contains [2021/08/14 21:59] (current) – [Examples] craigt
Line 21: Line 21:
 =====Examples===== =====Examples=====
  
-  contains('Mount St. Helens', 'Mount'TRUE +  contains('Mount St. Helens', 'Mount'//Returns TRUE 
-  contains('Mount Killimanjaro', 'Mountain'FALSE + 
-  contains('Mont Blanc', 'blanc'= FALSE  //Non-matching cases. +  contains('Mount Killimanjaro', 'Mountain'//Returns FALSE 
-  contains([Mtn_Name],'Everest'= TRUE  //Using a field name; if [Mtn_Name] is 'Mount Everest' + 
-  contains([Mtn_Name], 'Everest'= FALSE  //Using a field name; if [Mtn_Name] is 'K2'+  contains('Mont Blanc', 'blanc') //Returns FALSE  (Non-matching cases.
 + 
 +  contains([Mtn_Name],'Everest') //Returns TRUE  (Using a field name; if [Mtn_Name] is 'Mount Everest'
 + 
 +  contains([Mtn_Name], 'Everest') //Returns FALSE  (Using a field name; if [Mtn_Name] is 'K2')
      
 For "per row" matching between two columns, field names can be used for both //text// and //look_for//. For "per row" matching between two columns, field names can be used for both //text// and //look_for//.
syntax/functions/contains.txt · Last modified: 2021/08/14 21:59 by craigt

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki