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. UNIQUELINES is case-sensitive when it checks for duplicates, and it compares all characters, including spaces.

When you specify a TEXT expression, the return value is TEXT. When you specify an NTEXT expression, the return value is NTEXT.

Examples

Example 26-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