Brian Dunning's FileMaker Custom Functions

BitOperation ( BitNr ; RC ; OPC ; OP1 ; OP2 )

bitwise logical operation

  Average rating: 4.2 (44 votes) Log in to vote

Erich Schmidt   Erich Schmidt - Show more from this author

Share on Facebook Share on Twitter

  Sample input:
BitOperation( 0 ; 0 ; 6 ; 145 ; 345)
BitOperation( 0 ; 0 ; 14 ; 5 ; 12)
BitOperation( 0 ; 0 ; 8 ; 5 ; 12)
  Sample output:

  Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

26.12.2016 - Latex-code added to generate a PDF-document containing a value table and some hints for application the function.
The code can be compiled with TexShop or the online Latex-compiler on the site
Function code is unchanged.

Function value is the result of any bitwise logical operation between the binary representation of the integer values OP1 and OP2. Only the 16 least significant bits are processed.
The operation is given by OPC, which can be any integer number from 0 to 15. OPC determines what operation is performed.

Requires other Custom Functions:

BitNr, RC these parameters must be set to 0 by the caller. Otherwise it leads to faulty results.
OP1; OP2 any integer values (numbers greater than 65,535 are possible, but
OPC can be any integer number from 0 to 15

OPC=0 is true, if OP1 AND NOT OP1 is true (never)
OPC=1 is true, if NOT (OP1 OR OP2) is true
OPC=2 is true, if NOT OP1 AND OP2 is true
OPC=3 is true, if NOT OP1 is true
OPC=4 is true, if OP1 AND NOT OP2 is true
OPC=5 is true, if NOT OP2 is true
OPC=6 is true, if OP1 XOR OP2 is true (exclusive or)
OPC=7 is true, if NOT (OP1 AND OP2) is true
OPC=8 is true, if OP1 AND OP2 is true (conjunction)
OPC=9 is true, if NOT ( OP1 XOR OP2) is true (equivalence)
OPC=10 is true, if OP2 is true
OPC=11 is true, if OP1 OR NOT OP2 is true
OPC=12 is true, if OP1 is true
OPC=13 is true, if OP1 OR NOT OP2 is true
OPC=14 is true, if OP1 OR OP2 is true (disjunction)
OPC=15 ist true, if OP1 OR NOT OP1 is true (always)

Some simple examples

Set bit 2 and bit 5 in OP1. All other bits leave unchanged.

BitOperation( 0 ; 0 ; 14 ; OP1 ; 2^2+2^5)

Toggle bit 0 , bit 3 and bit 12 in OP1. All other bits leave unchanged.

BitOperation( 0 ; 0 ; 6 ; OP1 ; 2^0+2^3+2^12)

Clear bits 8 and 9 in OP1. All other leave unchanged.

BitOperation( 0 ; 0 ; 4 ; OP1 ; 2^8+2^9)

Check, if one of bit 3 or 5 in OP1 is set.

It‘s true, if the expression BitOperation( 0 ; 0 ; 8 ; OP1 ; 2^3+2^5) is true (not 0).

The following Latex-code can be used for generating a PDF-document with a value table for the functions and some hints for application. Copy the text after this line:

%! program = pdflatex

\documentclass[10pt,a4paper,article]{memoir} % for a short document

\title{Value Table Logical Operations With Two Operands\\Hints for Using in FileMaker}
\author{Erich Schmidt\\ }
\date{26.12.2016} % Delete this line to display the current date
\usepackage[applemac]{inputenc} %Umlaute und ß



\copyright \ 2016 Erich Schmidt
\subsection{The value table:}
&& &&&&&&&O&P&C&&&&&&\\
OP1&OP2&0 &1&2&3&4&5&6&7&8&9&10&11&12&13&14&15\\
0&0 &0 & 1 & 0 & 1 & 0 & 1& 0 & 1& 0 & 1& 0 & 1& 0 & 1& 0 & 1\\
0&1 & 0 & 0 & 1& 1 & 0 & 0 & 1& 1& 0 & 0 & 1& 1& 0 & 0 & 1& 1\\
1&0 &0 & 0 &0 & 0 &1 & 1 &1 & 1&0 & 0 &0 & 0 &1 & 1 &1 & 1\\
1&1 & 0 & 0 & 0 & 0& 0 & 0 & 0 & 0&1 & 1 &1 & 1&1 & 1 &1 & 1\\
\subsection{Notes and hints:}
\item The table provides an overwiew of the values of the function \[BitOp(OPC;OP1;OP2)\]
for every possible constellation of bits in OP1 and OP2. The benefit is that only one function
needs to be used for bitwise logical Operations like AND, OR, XOR, NOT and so on.
\item Note that in general the operations are not commutative. That means you get different
results if you write BitOP(OPC;OP2;OP1) instead of BitOP(OPC;OP1;OP2).
The commutative operations are those that give in line two and line three the same result.
These are OPC=0, 1, 6, 7, 8, 9, 14 and 15.
\item As you can see is OPC=6 is a bitwise XOR-operation. The XOR returns a value 1 (true),
if the bits in OP1 and OP2 are unequal and a value of 0 (false) else. You also can see, that
OPC=9 is the negation of the result of OPC=6. If OPC=6 returns a 0, so OPC=9 returns a 1 and
vice versa. But now is 6+9=15. This is general context. Whatever an operation OPC returns,
the operation, 15-OPC returns exactly the opposite (the bitwise negation).
\item As can be seen are for OPC=3 the function values the negation of OP1. This means that the
values given by OPC=3 do not depend from the value of OP2. Consequently it doesn't care
what value OP2 has. The function result is always the negation of OP1.
Assumed you perform any operation OPC that returns a value X. If you intend subsequently
perform a negation from X using by OPC=3, then it is an improved performance to do these
in one step. Because of what is mentioned above you get the negation of X by executing of
only one function call with 15-OPC instead of OPC.
\item Now have a look at OPC=5, OPC=10 and OPC=12. All these are also only dependig from
one operand, because first of them gives the negation of OP2 and the other ones OP2 and OP1 itself.
\item Finally there are two operations giving always the same value independend of both operands.
These are OPC=0 (returns always 0) and OPC=15 (returns always 65535). They have no importance for practice,
as well as OPC=10 and OPC=12, because the result is known before performing the operations. In case of OPC=10 and OPC=12 is the result equal to one of the operands, in case of OPC=0 and OPC=15 is the result constant.



Log in to post comments.


Note: these functions are not guaranteed or supported by Please contact the individual developer with any questions or problems.

Support this website.

This library has been a free commmunity resource for FileMaker users and developers for 15 years. It receives no funding and has no advertisements. If it has helped you out, I'd really appreciate it if you could contribute whatever you think it's worth: