SEARCHB

SEARCHB the location of the search string within text after byte position start

Synopsis

SEARCHB(search,text,start)

Arguments

search: search string

text: search field

start: starting byte position, defaults to 1

Description

search may contain wildcard characters (*) and question marks (?). A question mark matches any single character, and a wildcard matches any string including the empty string. To search for * or ?, precede the symbol with ~.

Note

This search is not case sensitive. If search is not found, SEARCHB returns #VALUE! If start is less than one or it is greater than the byte length of text, SEARCHB returns #VALUE! The semantics of this function is subject to change as various applications implement it.

Microsoft Excel Compatibility

While this function is syntactically Excel compatible, the differences in the underlying text encoding will usually yield different results.

OpenDocument Format (ODF) Compatibility

While this function is OpenFormula compatible, most of its behavior is, at this time, implementation specific.

See also

FINDB, SEARCH.