The MID function returns a sub-string of the input string, starting from the specified offset.
Input | Data Type | Description |
---|---|---|
Input1 | String | The original string. |
Input2 | Integer | Sets the Offset property. (optional) |
Input3 | Integer | Sets the Count property. (optional) |
Output | Data Type | Description |
---|---|---|
Output1 | String | The sub-string. |
Name | Property Type | Description |
---|---|---|
Offset | Integer | The character position the sub-string is to start from. The first character in the original string is position 1. |
Count | Integer | The number of characters to include in the new string.
If set to -1, all the characters from the Offset to the end of the original string will be included in the new string. |
Offset + Count
is larger than the number of characters in the string, the sub-string starting from the Offset to the end of the string is returned.Property | Output | |||
Input 1 | abcdefghijklmnop | Offset | 3 | cd |
Count | 2 |