FIND Function: Difference between revisions
From Planfix
(Created page with "== Go To == * Standard operators and Planfix functions *Calculated fields *Reports") |
No edit summary |
||
| Line 1: | Line 1: | ||
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 == | == Go To == | ||
*[[Standard functions | Standard operators and Planfix functions]] | *[[Standard functions | Standard operators and Planfix functions]] | ||
*[[Calculated fields]] | *[[Calculated fields]] | ||
*[[Reports]] | *[[Reports]] | ||
Revision as of 01:51, 11 February 2021
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";Template:Task.Name