Skip to main content

MIDB

Extracts the characters from the specified string starting from any position and is intended for languages that use the double-byte character set (DBCS) like Japanese, Chinese, Korean etc.

Syntax

expression.MIDB(arg1, arg2, arg3);

expression - A variable that represents a ApiWorksheetFunction class.

Parameters

NameRequired/OptionalData typeDefaultDescription
arg1RequiredApiRange | ApiName | stringThe text string from which to extract the characters.
arg2RequiredApiRange | ApiName | numberThe position of the first character to extract. The first text character is 1.
arg3RequiredApiRange | ApiName | numberA number of the characters to extract, based on bytes.

Returns

string

Example

This example shows how to extract the characters from the specified string starting from any position and is intended for languages that use the double-byte character set (DBCS) like Japanese, Chinese, Korean etc.

// How to get an array of characters from the specified position.

// Use a function to get an array of characters from the string.

let worksheet = Api.GetActiveSheet();
let func = Api.GetWorksheetFunction();
worksheet.GetRange("A1").SetValue(func.MIDB("Online Office", 3, 4));