Binary functions
Binary functions functions for Power Query M language.
Functions
| Function | Description |
|---|---|
| #binary | Generates a digital value from a series of numerical inputs or a text value encoded in base 64. |
| Binary.ApproximateLength | Returns an estimated measurement of the binary data length, or presents an error message if the data source does not have the capability to provide an estimated length. |
| Binary.Buffer | This operation saves the binary value in the computer's memory. The outcome is a consistent binary value with a specific length and byte order. |
| Binary.Combine | Merges a set of individual binary files into one single binary file. |
| Binary.Compress | This function compresses a binary value using the specified compression type. The output of this function will be a compressed version of the input data. Supported compression types are Compression.GZ... |
| Binary.Decompress | Unpacks a binary value by utilizing the specified compression method. The output of this operation is an uncompressed duplicate of the original input. Supported compression methods are Compression.GZi... |
| Binary.From | This function retrieves a binary value based on the input value provided. If the input value is null, the function will return null. If the input value is already in binary form, it will be returned a... |
| Binary.FromList | This process transforms a series of numerical values into binary form. |
| Binary.FromText | This function returns the outcome of converting a text value to a binary form, represented as a list of numbers. Users can specify the encoding format used in the text value. The available encoding fo... |
| Binary.InferContentType | The function returns a data record with the field Content.Type, which specifies the MIME-type inferred from the content. In the case where the inferred content type is text/* and an encoding code page... |
| Binary.Length | This function calculates and returns the total count of characters in a given input. |
| Binary.Range | Returns a portion of the binary number starting at a specific position. The optional offset parameter determines the maximum size of the portion. |
| Binary.Split | Divides a binary data into smaller binaries, creating a list of these smaller binaries. The first element in the list contains the initial set of bytes specified by the pageSize, the following element... |
| Binary.ToList | The process involves transforming a binary number into a sequence of numerical values. |
| Binary.ToText | This function returns the text value resulting from converting a binary list of numbers into a text value. An encoding can be specified to determine how the text value is generated. The available enco... |
| Binary.View | The binary view function allows for the customization of operation behavior by specifying handler functions. These handlers are used instead of the default behavior when an operation is applied to the... |
| Binary.ViewError | Generates an altered error log based on the original errorRecord. This adjusted log will not initiate a default response if it is raised by a handler specified on a view through Binary.View. |
| Binary.ViewFunction | Generates a view function that can be managed within a view created by Binary.View. The OnInvoke handler of Binary.View is utilized to establish a handler for the view function. Analogous to the handl... |
| BinaryFormat.7BitEncodedUnsignedInteger | A data format which can interpret a 64-bit unsigned number that has been compressed using a variable-length encoding method with 7 bits. |
| BinaryFormat.Binary | This function produces a binary representation that interprets a binary value. If a specific length is indicated, the binary value will consist of that exact number of bytes. If no length is indicated... |
| BinaryFormat.Byte | A data format that interprets a single byte as an integer value ranging from 0 to 255. |
| BinaryFormat.ByteOrder | The function produces a binary output with the byte arrangement indicated by binaryFormat. The standard byte order used is ByteOrder.BigEndian if not otherwise specified. |
| BinaryFormat.Choice | This function returns a binary format that dynamically selects the next binary format based on a previously obtained value. The process follows these steps: 1. Use the binary format specified by the ... |
| BinaryFormat.Decimal | A binary format that interprets a 16-byte decimal value in the .NET framework. |
| BinaryFormat.Double | A file format designed to interpret an 8-byte IEEE double-precision floating point number. |
| BinaryFormat.Group | The parameters to be considered are the following: - The binaryFormat parameter defines the binary format of the key value. - The group parameter provides details about the group of known items. - The... |
| BinaryFormat.Length | The function returns a binary format with restricted data reading capabilities. BinaryFormat.List and BinaryFormat.Binary can be utilized to read data until the end, while BinaryFormat.Length can be u... |
| BinaryFormat.List | This function returns a list of items by reading a sequence in binary format. The binaryFormat parameter determines the format of each item. There are three ways to decide how many items are read: 1.... |
| BinaryFormat.Null | A binary format that interprets a sequence of zero bytes as a null value. |
| BinaryFormat.Record | This function outputs a binary format for reading a record, with the format of the record specified by the record parameter. Each field within the record may have a distinct binary format. In cases wh... |
| BinaryFormat.SignedInteger16 | A binary structure capable of interpreting a 16-bit signed integer. |
| BinaryFormat.SignedInteger32 | A file format that can interpret a 32-bit signed integer. |
| BinaryFormat.SignedInteger64 | A binary format is utilized to interpret a 64-bit signed integer value. |
| BinaryFormat.Single | A computer format that can interpret a 4-byte IEEE single-precision floating point number. |
| BinaryFormat.Text | This function retrieves a binary format of a string value. The length parameter indicates the number of bytes to be decoded, or the binary representation of the text's length that comes before the act... |
| BinaryFormat.Transform | This function returns a binary format that can convert values read by another binary format. The binaryFormat parameter indicates the specific binary format that will be utilized to read the value. Up... |
| BinaryFormat.UnsignedInteger16 | A file format that interprets a 16-bit unsigned integer. |
| BinaryFormat.UnsignedInteger32 | A binary structure that interprets a 32-bit unsigned whole number. |
| BinaryFormat.UnsignedInteger64 | A data format that can interpret a 64-bit unsigned whole number. |
| Combiner functions | No description available |
| Combiner.CombineTextByDelimiter | This function returns a result of combining multiple text values in a list, using a designated separator. |