Skip to main content

TrText_UniqueLines (function reference)

By October 1, 2024October 10th, 2024Online Help, Troi Text Plug-in
Troi Text Plug-in > Functions reference > TrText_UniqueLines
Troi Text Plug-in for FileMaker Pro

TrText_UniqueLines

Returns all unique lines from theText. You can use this function in calculation field definitions or in script calculations.

SyntaxFunction badge

TrText_UniqueLines ( switches ; theText )

Parameters

switches (optional) determine the way the result is returned
theText the text for which the unique lines have to be found

Switches

Switches can be empty or:

-ReturnAtEnd add a return character at the end
-Unused use this to make clear switches are not used, you can also use ""

Returned Result

Data type returned

Text

Result

All unique lines from theText.

Originated in

Troi Text Plug-in 1.2

Compatibility

FileMaker Pro 17 to FileMaker Pro 21 (2024)

Considerations

This function ignores the case of the lines while comparing. The line that is included in the result has the same case as the first line that’s compared.

Example

Set Field [ result ; TrText_UniqueLines ( "-Unused" ; theText ) ]

Say text field “theText” consists of the following lines:
this is a line
this is another line
These are the same
THESE are the same

Then result will be:
this is a line
this is another line
These are the same

Example 2

Text field “Text1” consists of the following lines:
12345
34567
12345
12345
34567

The result of UniqueLines will be:
12345
34567

Related topics

Troi Text Plug-in online help (overview)


Online Help Page for Troi Text Plug-in for 17 to 2024 –> TrText_UniqueLines (textp13) 2024-1010 14:50:55