The LEFTB function outputs the first (left) N bytes specified by the Count
property.
If the input is a String, the data is first converted to binary code according to the specified Encoding
type. Then the first (left) N bytes specified by the Count
property are output.
Input | Data Type | Description |
---|---|---|
Input1 | Binary,String | The data. |
Input2 | Integer | Sets the Count property. (optional) |
Output | Data Type | Description |
---|---|---|
Output1 | Binary,String | The selected data. |
Name | Property Type | Description | |||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Count | Integer | Specifies the number of bytes to output. | |||||||||||||||
Encoding | choice | If the input is a String, this property specifies the type of encoding used to convert it to binary code. Also, this encoding is used to encode the output String.
|
|||||||||||||||
OutputType | choice | Specifies the output's data type.
|
Count
property will result in an error. The mapper component that this function is in will abort and throw an exception.Count
property is greater than the number of bytes in the input data, the entire input data is output.Count
property is 0, zero bytes of data are output.The binary representation of a string is dependant on its encoding scheme. Two different encoding schemes may have the same binary representation of a text string. Similarly, two different encoding schemes may have different binary representations for the same text string. Below are some encoding schemes and their resulting binary representations for the string "aeiou".
euc-jp: 61 65 69 6F 75
shift_jis: 61 65 69 6F 75
utf-8: 61 65 69 6F 75
utf-16: FE FF 00 61 00 65 00 69 00 6F 00 75
The Binary Functions LEFTB, RIGHTB, MIDB, REPLACEB and TRUNCATEB handle input streams differently, depending on the input's data type. Binary data is processed as it is. Any other type of input, other than binary data, is first converted to a string (a string is left as is), and then this string is then converted to its binary form according to the encoding scheme selected.
The LEFTB, RIGHTB, MIDB, REPLACEB and TRUNCATEB functions can output the processed binary data or convert it to the specified encoding scheme's string representation for output.
If binary data cannot be successfully converted back to a string, an empty string is output.
Property | Output | |||
Input1 | 0x6165696F75 | Count | 2 | 0x6165 |
Encoding | utf-8 | |||
OutputType | Binary |
Property | Output | |||
Input1 | 0x6165696F75 | Count | 2 | ae |
Encoding | utf-8 | |||
OutputType | String |