REMLINES

The REMLINES function removes one or more lines from a multiline TEXT expression and returns the value that remains.

Return Value

TEXT or NTEXT

Syntax

REMLINES(text-expression start [length])

Arguments

text-expression: A multiline text expression from whose values REMLINES removes one or more lines. When you specify a TEXT expression, the return value is TEXT. When you specify an NTEXT expression, the return value is NTEXT.
start: An INTEGER that represents the line number at which to begin removing lines. The position of the first line in text-expression is 1.
length: An INTEGER that represents the number of lines to be extracted. When you do not specify length, only the line at start is removed.

Examples

Example 8-75 Removing Text Lines

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

Salespeople
Products
Services

The statement

SHOW REMLINES(mktglist, 2)

produces the following output.

Salespeople
Services