FIND Function: Difference between revisions

From Planfix
Jump to: navigation, search
No edit summary
No edit summary
 
Line 1: Line 1:
{{#seo:
|title=FIND Function
|titlemode=append
|keywords=planfix, Function, FIND
|description=FIND Function
}}
The FIND() function finds an occurrence of one text string within another and returns the initial position of the search string relative to the first character of the second string.
The FIND() function finds an occurrence of one text string within another and returns the initial position of the search string relative to the first character of the second string.
*The function is case-sensitive
*The function is case-sensitive
Line 9: Line 15:
FIND(search_text;string)
FIND(search_text;string)


''Example:''
''Example:''


FIND("urgent";<nowiki>{{Task.Name}}</nowiki>)
FIND("urgent";<nowiki>{{Task.Name}}</nowiki>)





Latest revision as of 07:28, 10 May 2024

The FIND() function finds an occurrence of one text string within another and returns the initial position of the search string relative to the first character of the second string.

  • The function is case-sensitive
  • If the substring is not found, the function returns -1.
  • If the empty string ("") is set as the argument for search_text, the FIND function will return 1.


Format:

FIND(search_text;string)

Example:

FIND("urgent";{{Task.Name}})


Go To