Oracle® OLAP DML Reference 11g Release 2 (11.2) Part Number E17122-07 |
|
|
PDF · Mobi · ePub |
The REMLINES function removes one or more lines from a multiline TEXT expression and returns the value that remains.
TEXT or NTEXT
REMLINES(text-expression start [length])
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.
An INTEGER
that represents the line number at which to begin removing lines. The position of the first line in text-expression is 1
.
An INTEGER
that represents the number of lines to be extracted. When you do not specify length, only the line at start is removed.