WORDSLICE

Return a substring of words from a start offset to an end offset

Example Usage

SLICE("The funny red fox", 0, 2) -> ""The funny""
SLICE("The funny red fox", 2, 3) -> ""red""
SLICE("The funny red fox", 1, ) -> "funny red fox"
SLICE("The funny red fox", -1, ) -> "fox"
SLICE("The funny red fox", -2, ) -> "red fox"
SLICE("The funny red fox", , -1) -> "The funny red"

Overview

Function signature
WORDSLICE(value, start, end)

Category
String

Return data type
string

Arguments

Name	DataType	List Options	Description
value	string		The source string to slice
start	int		The start offset of the substring; if omitted it starts at the beginning; if negative it starts backwards from the end
end	int		The end offset of the substring; if omitted the slice toes to the end; if negative it counts backwards from the end