TrText_ANDText (function reference)

By November 1, 2017 November 13th, 2017 Online 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
text1first text
text2second text

Switches

Switches can be empty or:

-ReturnAtEndadd a return character at the end
-Unuseduse 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 12 to 16

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 12 to 16 –> TrText_ANDText (textp5) 2017-1112 16:52:57