Skip to content

search

Find one string within another (case-insensitive).

v = search(find_text, within_text, start_num)

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.

search('world', 'hello world') % 7
search('o', 'hello world', 5) % 8
  • find — Find one string within another (case-sensitive, no wildcards).
  • strfind — Find one string within another.