UNIQUELINES

The UNIQUELINES function removes duplicate lines in a multiline TEXT value and sorts the lines in ascending order. The function returns a multiline TEXT value composed of the resulting lines.

Return Value

TEXT or NTEXT

Syntax

UNIQUELINES(text-expression)

Arguments

text-expression: A multiline text expression from which UNIQUELINES removes duplicate lines and in which it sorts the remaining lines. When you specify a TEXT expression, the return value is TEXT. When you specify an NTEXT expression, the return value is NTEXT.

Notes

Case Sensitivity

UNIQUELINES is case-sensitive when it checks for duplicates, and it compares all characters, including spaces.

Sort Order

UNIQUELINES sorts the lines in ascending order.

Examples

Example 24-22 Removing Duplicate Text Lines

In the following example, one line is removed from the value of officelist, and the lines are sorted.

The statement

SHOW officelist

produces the following output.

MIAMI
Providence
Miami
Baltimore
Saratoga
Baltimore

The statement

show uniquelines(officelist)

produces the following output.

Baltimore
Miami
MIAMI
Providence
Saratoga