FINDB
function FINDB(arg1: string = null, arg2: string = null, arg3: number = null): numberDescription
Finds the specified substring within another 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. Use double quotes (empty text) to match the first character in the search string. Wildcard characters are not allowed.
- arg2
stringdefault: null The text containing the text to find.
- arg3
numberdefault: null Specifies the character at which to start the search. The first character in the search string is character number 1. If omitted, this parameter is equal to 1.
Returns
numberTry It
var oWorksheet = Api.GetActiveSheet();
var oFunction = Api.GetWorksheetFunction();
oWorksheet.GetRange("A1").SetValue(oFunction.FINDB("line", "Online Office"));