Power Query
Search…
BinaryFormat.Record

BinaryFormat.Record

Returns a binary format that reads a record.
function (record as record) as function

Description

Returns a binary format that reads a record. The record parameter specifies the format of the record. Each field in the record can have a different binary format. If a field contains a value that is not a binary format value, then no data is read for that field, and the field value is echoed to the result.

Category

Binary Formats.Reading records

Examples

Read a record containing one 16-bit integer and one 32-bit integer.
1
let
2
binaryData = #binary({
3
0x00, 0x01,
4
0x00, 0x00, 0x00, 0x02}),
5
recordFormat = BinaryFormat.Record([
6
A = BinaryFormat.UnsignedInteger16,
7
B = BinaryFormat.UnsignedInteger32
8
])
9
in
10
recordFormat(binaryData)
Copied!
[A = 1, B = 2]
Last modified 3yr ago