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