![]() Previous |
![]() Next |
The EXTLINES function extracts lines from a multiline text expression.
Return Value
TEXT
or NTEXT
Syntax
EXTLINES(text-expression [start [numlines]])
Parameters
A multiline TEXT
or NTEXT
expression from whose values one or more lines are to be extracted.
An INTEGER
that represents the line number at which to begin extracting. The position of the first line in text-expression is 1
. When you omit this argument, EXTLINES begins with line 1.
An INTEGER
representing the number of lines to be extracted. When you do not specify numlines, or when you specify a number greater than the number of lines from start to the end of text-expression, all the lines from start to the end of text-expression are copied.
Examples