Syntax
TEXT2HEX(<string>;<number>;<string>)
Description
TEXT2HEX returns each character's unicode value represented in hexadecimal. The second argument (optional) indicates after how many characters a delimiter should appear in the hexadecimal representation - the default is zero. The third argument indicates which character(s) should be used as a delimiter. The default delimiter is a hyphen (-).
Examples
Column1 | argument1 | argument2 | TEXT2HEX returns |
|---|---|---|---|
Hello | 48656c6c6f | ||
Hello | 2 | 48-65-6c-6c-6f | |
Hello | 3 | 486-56c-6c6-f | |
Hello | 2 | / | 48/65/6c/6c/6f |