MID 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.
