SEARCH function
From Planfix
The SEARCH() function finds one text string within another and returns the starting position of the first text string relative to the first character of the second text string.
- The function is not 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 SEARCH function will return 1.
- Wildcards can be used in the argument for search_text: question mark (?) and asterisk (*). Question marks match any character; asterisks match any sequence of characters. If you need to include a question mark or asterisk in the search text, put a tilde (~) before the symbol in the argument.
Format:
SEARCH(search_text;string)
SEARCH(search_text;string)
Example:
SEARCH("BOAT*down?he stream";"Row, row, row your boat, gently down the stream") //returns 20
SEARCH("What's up~?"; "Did he ask you what's up?") //returns 16
SEARCH("apple?";"one apple two apples") //returns 5
MID({{Task.Field}};Search(",";{{Task.Field}})+2;1000) // returns Tom, if Task.Field="Hello, Tom"