EXTLINES

The EXTLINES function extracts lines from a multiline text expression.

Return Value

TEXT or NTEXT

Syntax

EXTLINES(text-expression [start [numlines]])

Arguments

text-expression: A multiline TEXT or NTEXT expression from whose values one or more lines are to be extracted.
start: 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.
numlines: 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

Example 12-8 Extracting One Text Line

This example shows how to extract the second line from a multiline text value in a variable called mktglist. The mktglist variable has the following values.

Salespeople
Products
Services

The statement

SHOW EXTLINES(mktglist 2 1)

produces the following output.

Products