BIT_NOT macro

The BIT_NOT macro is available in IBM® Campaign and IBM® Interact.

The non-negative integers to bitwise NOT. This can be a constant value, a column, a cell range, or an expression evaluating to any of the above. For the format definition of data, see the "Macro Function Parameters" section in the chapter in this guide for your IBM® product.

Description

BIT_NOT calculates the bitwise NOT of the values in the specified data range. It returns one new column for each input column, each containing the bitwise NOT of the values in the corresponding columns of data.

Precision for this macro function is limited to integer values less than

. No negative values are allowed.

Using a column containing the same number x in each row as data is the same as using the constant x as data.

The BIT_NOT operator can be abbreviated with a tilda (~). Use the tilda before the data value (for example, to specify BIT_NOT(V1), you can simply type ~V1.

Examples

TEMP = BIT_NOT 3 or TEMP = ~3

Creates a new column named TEMP containing the value four (bitwise NOT of 011 equals 100).

TEMP = ~V1

Creates a new column named TEMP, where each value is the bitwise NOT of the contents of column V1.

TEMP = ~V1:V3

Creates three new columns named TEMP, VX, and VY. The values in the TEMP column are the bitwise NOT of the contents of column V1, the values of the VX column are the bitwise NOT of the contents of column V2, and the values of the VY column are the bitwise NOT of the contents of column V3.

TEMP = ~V1[100:200]

Creates a new column named TEMP, where the first 101 cells contain the bitwise NOT of the values in rows 1-50 of column V1.

Related Functions

Function	Description
BIT_AND	Computes the bitwise AND between two specified data ranges
BIT_OR	Computes the bitwise OR between two specified data ranges
BIT_XOR or XOR	Computes the bitwise XOR between two specified data ranges