Extracts a portion of text starting from a specified position with a given length
Description | The |
Syntax | MID( |
Output | text |
Variables
text
: The input text from which you want to extract subtext.start
: The starting position within the text. The start position begins at 1.length
: (Optional) The length of the subtext to be extracted.
Example
MID(`Product Code`,4)
ID | Product Code | MID |
1 | ELE12345 | 12,345 |
2 | CLO67890 | 67,890 |
3 | FOO45678 | 45,678 |