HEXTOBIN

Returns a binary value from a hexadecimal value.

Syntax

HEXTOBIN(hexValue)

  1. hexValue - the hexadecimal value which should be converted to a binary value - Value type: text

Remarks

  1. The function returns the binary representation of hexValue, as a text containing 0 and 1 (like “100101").

  2. A negative hexValue returns a negative binary value.

Examples

Example 1 - HEXTOBIN of a single value:

Example 2 - HEXTOBIN for a range of values:

Last updated