Skip to main content

TrText_ANDText (function reference)

By December 1, 2021December 21st, 2021Online Help, Troi Text Plug-in
Troi Text Plug-in for FileMaker Pro

TrText_ANDText

Returns all lines that are both in text1 and text2.

SyntaxFunction badge

TrText_ANDText ( switches ; text1 ; text2 )

Parameters

switches (optional) determine way the result is returned
text1 first text
text2 second text

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 lines that are both in text1 and text2.

Originated in

Troi Text Plug-in 1.2

Compatibility

FileMaker Pro 16 to 19

Considerations

This is one of the 3 set manipulation functions.

Example

Set Field [ result ; TrText_ANDText ( "-Unused" ; Text1 ; Text2 ) ]

If Text1 contains:
AA
BB
and Text2 contains:
BB
CC
then the result will be:
BB

Example 2

Text field “Text1” consists of the following lines:
1
10
12

And field “Text2” consists of the these lines:
1
2

The result of ANDText will be:
1

Related functionsFunction badge

TrText_NOTText
TrText_XORText

Related topics

Troi Text Plug-in online help (overview)


Online Help Page for Troi Text Plug-in for 16 to 19 –> TrText_ANDText (textp5) 2021-1221 14:54:39