SEARCH
function SEARCH(arg1: string = null, arg2: string = null, arg3: number = null): numberDescription
Returns the number of the character at which a specific character or text string is first found, reading left to right (not case-sensitive).
Parameters
- arg1
stringdefault: null The text to find. The ? and * wildcard characters can be used. Use ~? and ~* to find the ? and * characters.
- arg2
stringdefault: null The text where to search for the specified text.
- arg3
numberdefault: null The character number in the search text, counting from the left, at which to start searching. If omitted, 1 is used.
Returns
numberTry It
var oWorksheet = Api.GetActiveSheet();
var oFunction = Api.GetWorksheetFunction();
oWorksheet.GetRange("A1").SetValue(oFunction.SEARCH("line", "Online Office"));