Power Query
Search…
BinaryFormat.Choice
BinaryFormat.Choice
Returns a binary format that chooses the next binary format based on a value that has already been read.
function (binaryFormatas function,chooseFunctionas function, optionaltypeas nullable any, optionalcombineFunctionas nullable function) as function
Description
Returns a binary format that chooses the next binary format based on a value that has already been read. The binary format value produced by this function works in stages:
The binary format specified by the
binaryFormat parameter is used to read a value.The value is passed to the choice function specified by the
chooseFunction parameter.The choice function inspects the value and returns a second binary format.
The second binary format is used to read a second value.
If the combine function is specified, then the first and second values are passed to the combine function, and the resulting value is returned.
If the combine function is not specified, the second value is returned.
The second value is returned.
Category
Binary Formats.Controlling what comes next
Examples
Read a list of bytes where the number of elements is determined by the first byte.
1
let
2
binaryData = #binary({2, 3, 4, 5}),
3
listFormat = BinaryFormat.Choice(
4
BinaryFormat.Byte,
5
(length) => BinaryFormat.List(BinaryFormat.Byte, length))
6
in
7
listFormat(binaryData)
Copied!
{3, 4}
Read a list of bytes where the number of elements is determined by the first byte, and preserve the first byte read.
1
let
2
binaryData = #binary({2, 3, 4, 5}),
3
listFormat = BinaryFormat.Choice(
4
BinaryFormat.Byte,
5
(length) => BinaryFormat.Record([
6
length = length,
7
list = BinaryFormat.List(BinaryFormat.Byte, length)
8
]))
9
in
10
listFormat(binaryData)
Copied!
[ length = 2, list = {3, 4} ]
Read a list of bytes where the number of elements is determined by the first byte using a streaming list.
1
let
2
binaryData = #binary({2, 3, 4, 5}),
3
listFormat = BinaryFormat.Choice(
4
BinaryFormat.Byte,
5
(length) => BinaryFormat.List(BinaryFormat.Byte, length),
6
type list)
7
in
8
listFormat(binaryData)
Copied!
{3, 4}
Last modified 3yr ago
Copy link