Articles with the tag:
Close
Changelog
Close
Articles with the tag:
Close
Try in the cloud

MID/MIDB Function

The MID/MIDB function is one of the text and data functions. Is used to extract the characters from the specified string starting from any position. The MID function is intended for languages that use the single-byte character set (SBCS), while MIDB - for languages that use the double-byte character set (DBCS) like Japanese, Chinese, Korean etc.

Syntax

MID(text, start_num, num_chars)

The MID function has the following arguments:

Argument Description
text A string you need to extract the characters from.
start_num A position you need to start extracting from.
num_chars A number of the characters you need to extract.

MIDB(text, start_num, num_bytes)

The MIDB function has the following arguments:

Argument Description
text A string you need to extract the characters from.
start_num A position you need to start extracting from.
num_bytes A number of the characters you need to extract, based on bytes.

Notes

How to apply the MID/MIDB function.

Examples

The figure below displays the result returned by the MID function.

MID Function

Return to previous page
Try now for free Try and make your decision No need to install anything
to see all the features in action