SEARCHB
function SEARCHB(arg1: string = null, arg2: string = null, arg3: number = null): numberDescription
Returns the location of the specified substring in a string and is intended for languages that use the double-byte character set (DBCS) like Japanese, Chinese, Korean etc.
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.SEARCHB("line", "Online Office"));