Multiline Text Functions

Table: MultiLine Text Functions lists the OLAP DML statements that you use to manipulate multiline text.

MultiLine Text Functions

Statement	Description
CHARLIST	Transforms an expression into a multiline text value with a separate line for each value of the original expression.
EXTCOLS	Extracts specified columns from each line of a multiline text value.
EXTLINES	Extracts lines from a multiline text expression.
FILTERLINES	Applies a filter expression that you create to each line of a multiline text expression.
FINDLINES	Determines the position of one or more lines in a multiline text expression.
INLIST	Determines whether every line of a text value is a line in a second text value.
INSCOLS	Inserts into the columns of a multiline TEXT value all the columns of another TEXT value.
INSLINES	Inserts one or more lines into a multiline text expression.
JOINCOLS	Joins the corresponding lines of two or more multiline text values.
JJOINLINES	Joins the values of two or more text expressions into a single multiline value.
MAXBYTES	The number of bytes in the longest line of a multiline text expression.
NUMLINES	The number of lines in each value of a text expression. The result returned by NUMLINES has the same dimensions as the specified expression.
REMCOLS	Removes specified columns from every line of a multiline TEXT value.
REMLINES	Removes one or more lines from a multiline TEXT expression and returns the value that remains.
REPLCOLS	Replaces some or all of the character columns in one multiline TEXT value with the columns of another.
REPLLINES	Replaces one or more lines in a multiline text expression.
SORTLINES	Sorts the lines in a multiline TEXT value.
UNIQUELINES	Removes duplicate lines in a multiline TEXT value and sorts the lines in ascending order.