# String functions

This section describes the following string functions:

| Function | Description |
| --- | --- |
| [BASE64_DECODE](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/string/base64_decode.htm) | Decode a base 64 string into a string |
| [BASE64_TO_HEX](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/string/base64_to_hex.htm) | Converts a base 64 string into a hex string |
| [BYTES_SUBSTRING](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/string/bytes_substring.htm) | Returns a substring of the input, using the offsets in bytes of the UTF-8 encoded byte representation. Partial characters and invalid UTF-8 code points are removed from the result |
| [CONCAT](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/string/concat.htm) | Returns the concatenation of string1, string2, ..., stringN |
| [DATE](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/string/date.htm) | Casts a string to a date |
| [JOIN_ARRAYS](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/string/join_arrays.htm) | Joins any number of arrays by index using a MessageFormat pattern |
| [LENGTH](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/string/length.htm) | Returns the length of the string |
| [LOWER](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/string/lower.htm) | Converts the string to lowercase letters |
| [LPAD](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/string/lpad.htm) | Pad the input string to the left with a given padding string up until size |
| [LTRIM](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/string/ltrim.htm) | Returns the given string without leading whitespaces |
| [MD5](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/string/md5.htm) | Hashes the input using MD5 |
| [PARSE_DATETIME](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/string/parse_datetime.htm) | Parses a string into a timestamp with time zone using a format |
| [REPLACE](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/string/replace.htm) | Replaces all instances of search with replace in input. If the search is empty, inserts replace in front of every character and at the end of the input |
| [REVERSE](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/string/reverse.htm) | Returns a string with the characters in reverse order |
| [RPAD](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/string/rpad.htm) | Pad the input string to the right with a given padding string up until size |
| [RTRIM](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/string/rtrim.htm) | Returns the given string without trailing whitespaces |
| [SHA1](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/string/sha1.htm) | Hashes the input using SHA-1 |
| [SHA256](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/string/sha256.htm) | Hashes the input using SHA-256 |
| [SHA3_512](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/string/sha3_512.htm) | Hashes the input using SHA3-512 |
| [SORT_VALUES](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/string/sort_values.htm) | Returns the values sorted in dictionary order |
| [SPLIT](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/string/split.htm) | Returns the given string split by the provided delimiter. Does not remove empty entries |
| [SPLIT_TO_RECORD](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/string/split_to_record.htm) | Returns the given string split by the provided delimiter |
| [STRING_FORMAT](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/string/string_format.htm) | Format any number of inputs into a string using the given format |
| [STRIP_MARGIN](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/string/strip_margin.htm) | For each line remove the prefix of control or whitespace characters followed by the given margin char |
| [STRIP_PREFIX](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/string/strip_prefix.htm) | Remove the given prefix string from the beginning of the string |
| [STRIP_SUFFIX](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/string/strip_suffix.htm) | Remove the given suffix string from the end of the string |
| [STRPOS](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/string/strpos.htm) | Returns the starting position of the first instance of a given substring within a string |
| [SUBSTR](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/string/substr.htm) | Extracts a substring of a certain length starting from a specified point within the given string |
| [SUBSTRING](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/string/substring.htm) | Extracts a substring of a certain length starting from a specified point within the given string |
| [TRANSLATE](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/string/translate.htm) | Translates the given value using a given dictionary |
| [TRIM](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/string/trim.htm) | Returns the given string without leading or trailing whitespaces |
| [TRIM_CHARS](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/string/trim_chars.htm) | Returns the given string without leading or trailing characters |
| [UPPER](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/string/upper.htm) | Converts the string to uppercase letters |
| [UUID_GENERATOR](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/string/uuid_generator.htm) | Returns UUID |
| [XX_HASH](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/string/xx_hash.htm) | Hashes the input using xxHash |