Returns text from anywhere in a string using the specified start and end positions. This function takes a string and two integer values as arguments and returns a string value. The positions of characters in a string are numbered from the left starting at zero. For example, the position before the first character is 0, and the position between the first and second character is 1.
Sub(<text_to_trim>, <start_position>, <end_position>)
The text to take characters from.
The position to start taking characters from in the text.
The position to stop taking characters from in the text.
- The expression Sub("The quick brown fox", 0, 3) returns
- The expression Sub("The quick brown fox", 10, 19) returns