| title | ms.date | ms.service | ms.reviewer | ms.topic | author | ms.author |
|---|---|---|---|---|---|---|
Binary.Range | Microsoft Docs |
11/23/2020 |
powerquery |
gepopell |
reference |
dougklopfenstein |
bezhan |
Binary.Range(binary as binary, offset as number, optional count as nullable number) as binary
Returns a subset of the binary value beginning at the offset binary. An optional parameter, offset, sets the maximum length of the subset.
Returns a subset of the binary value starting at offset 6.
Binary.Range(#binary({0..10}), 6)
#binary({6, 7, 8, 9, 10})
Returns a subset of length 2 from offset 6 of the binary value.
Binary.Range(#binary({0..10}), 6, 2)
#binary({6, 7})