search
Find one string within another (case-insensitive).
Syntax
Section titled “Syntax”v = search(find_text, within_text, start_num)Description
Section titled “Description”Returns the position (1-based) of the first occurrence of find_text in within_text, starting from start_num (default 1). Case-insensitive; supports ? and * wildcards. Raises #VALUE! if no match.
Examples
Section titled “Examples”search('world', 'hello world') % 7search('o', 'hello world', 5) % 8