The StringPart() function splits a text into an array of text values, and returns the part at a specified position.
This function is NOT SQL compatible. For more information about SQL compatibility, see our documentation.
Returns the part of a text that can be determined by splitting it on the indicated separator and then taking the resulting part at the indicated position.
Returns Invalid expression if one of the parameters is not valid.
| Name | Type | Required | Description |
|---|---|---|---|
text
text
The text to split
separator
text
Specifies the character(s) to use for separating the text
position
text
The position of the part to return