Preface
The Transformation Language
Constants
Operators
Variables
Dates
Functions
- Function Categories
  - Aggregate Functions
  - Aggregate Functions and Nulls
    - Filter Conditions
  - Binary Functions
  - Character Functions
  - Conversion Functions
  - Data Cleansing Functions
  - Date Functions
  - Encoding Functions
  - Financial Functions
  - Numeric Functions
  - Scientific Functions
  - Special Functions
  - String Functions
  - Test Functions
  - Variable Functions
  - Window Functions
- ABORT
- ABS
- ADD_TO_DATE
- AES_DECRYPT
- AES_ENCRYPT
- ASCII
- AVG
- BINARY_COMPARE
- BINARY_CONCAT
- BINARY_LENGTH
- BINARY_SECTION
- CEIL
- CHOOSE
- CHR
- CHRCODE
- COMPRESS
- CONCAT
- CONVERT_BASE
- COS
- COSH
- COUNT
- CRC32
- CUME
- DATE_COMPARE
- DATE_DIFF
- DEC_BASE64
- DEC_HEX
- DECODE
- DECOMPRESS
- EBCDIC_ISO88591
- ENC_BASE64
- ENC_HEX
- ERROR
- EXP
- FIRST
- FLOOR
- FV
- GET_DATE_PART
- GREATEST
- IIF
- IN
- INDEXOF
- INITCAP
- INSTR
- ISNULL
- IS_DATE
- IS_NUMBER
- IS_SPACES
- LAG
- LAST
- LAST_DAY
- LEAD
- LEAST
- LENGTH
- LN
- LOG
- LOOKUP
- LOWER
- LPAD
- LTRIM
- MAKE_DATE_TIME
- MAX (Dates)
- MAX (Numbers)
- MAX (String)
- MD5
- MEDIAN
- METAPHONE
- MIN (Dates)
- MIN (Numbers)
- MIN (String)
- MOD
- MOVINGAVG
- MOVINGSUM
- NPER
- PERCENTILE
- PMT
- POWER
- PV
- RAND
- RATE
- REG_EXTRACT
- REG_MATCH
- REG_REPLACE
- REPLACECHR
- REPLACESTR
- REVERSE
- ROUND (Dates)
- ROUND (Numbers)
- RPAD
- RTRIM
- SETCOUNTVARIABLE
- SET_DATE_PART
- SETMAXVARIABLE
- SETMINVARIABLE
- SETVARIABLE
- SHA256
- SIGN
- SIN
- SINH
- SOUNDEX
- SQRT
- STDDEV
- SUBSTR
- SUM
- SYSTIMESTAMP
- TAN
- TANH
- TIME_RANGE
- TO_BIGINT
- TO_CHAR (Dates)
- TO_CHAR (Numbers)
- TO_DATE
- TO_DECIMAL
- TO_FLOAT
- TO_INTEGER
- TRUNC (Dates)
- TRUNC (Numbers)
- UPPER
- VARIANCE
Creating Custom Functions
Custom Function API Reference

Transformation Language Reference

10.5
- 10.5.6
- 10.5.1
- 10.4.0

Back Next

BINARY_SECTION

Returns a portion of a binary value.

To use the

BINARY_SECTION

function, set the environment variable

INFA_ENABLE_BINARY_FUNCTIONS

to True or Yes.

Syntax

BINARY_SECTION( binary, start [,length] )

The following table describes the argument for this command:

Argument	Required/ Optional	Description
binary	Required	You can enter a binary value or any transformation expression that returns a binary datatype.
start	Required	You can enter an integer or any transformation expression that returns an integer. The position in the binary where you want to start counting. If the start position is a positive number, BINARY_SECTION locates the start position by counting from the beginning of the input binary. If the start position is a negative number, BINARY_SECTION locates the start position by counting from the end of the input binary. If the start position is 0, BINARY_SECTION searches from the first byte in the input binary.
length	Optional	You can enter an integer greater than 0 or any transformation expression that returns a positive integer. The number of bytes you want BINARY_SECTION to return. If you omit the length argument, BINARY_SECTION returns all of the bytes from the start position to the end of the input binary. If you pass a negative integer or 0, the function returns an error.

Return Value

Binary.

NULL if the input is a null value.

Example

The following expressions return the first three bytes of a binary value.

BINARY_SECTION( SYSID, 0, 3 )

SYSID (Shown in Hex)	RETURN VALUE (Shown in Hex)
0x00010203	0x000102
0x0405060708	0x040506
NULL	NULL

The following expressions return bytes 4 through 8 of a binary value.

BINARY_SECTION( SYSID, 4, 5 )

SYSID (Shown in Hex)	RETURN VALUE (Shown in Hex)
0x000102030405060708	0x0304050607
0x0405060708090A0B	0x0708090A0B
NULL	NULL

You can also pass a negative start value. The expression still reads the source binary from left to right when returning the result of the length
argument: