Troi Text Plug-in > Functions reference > TrText_ANDText
 |
TrText_ANDText |
Returns all lines that are both in text1 and text2.
Syntax
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 17 to FileMaker Pro 21 (2024)
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 functions
| TrText_NOTText |
| TrText_XORText |
Related topics
Troi Text Plug-in online help (overview)
