TrText_UniqueLines |
Returns all unique lines from theText. You can use this function in calculation field definitions or in script calculations.
Syntax
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)