# Funções de cadeia de caracteres

Esta seção descreve as seguintes funções de string:

| Função | Descrição |
| --- | --- |
| [BASE64_DECODE](https://help.qlik.com/pt-BR/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/string/base64_decode.htm) | Decodifica uma string base 64 em uma string |
| [BASE64_TO_HEX](https://help.qlik.com/pt-BR/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/string/base64_to_hex.htm) | Converte uma string base 64 em uma string hex |
| [BYTES_SUBSTRING](https://help.qlik.com/pt-BR/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/string/bytes_substring.htm) | Retorna uma substring da entrada, usando os deslocamentos em bytes da representação de byte codificada em UTF-8. Caracteres parciais e pontos de código UTF-8 inválidos são removidos do resultado |
| [CONCAT](https://help.qlik.com/pt-BR/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/string/concat.htm) | Retorna a concatenação de string1, string2, ..., stringN |
| [DATE](https://help.qlik.com/pt-BR/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/string/date.htm) | Converte uma string em data |
| [JOIN_ARRAYS](https://help.qlik.com/pt-BR/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/string/join_arrays.htm) | Une qualquer número de arrays por índice usando um padrão MessageFormat |
| [LENGTH](https://help.qlik.com/pt-BR/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/string/length.htm) | Retorna o comprimento da string |
| [LOWER](https://help.qlik.com/pt-BR/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/string/lower.htm) | Converte a string em letras minúsculas |
| [LPAD](https://help.qlik.com/pt-BR/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/string/lpad.htm) | Preenche a string de entrada à esquerda com uma determinada string de preenchimento até o tamanho |
| [LTRIM](https://help.qlik.com/pt-BR/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/string/ltrim.htm) | Retorna a string fornecida sem espaços em branco à esquerda |
| [MD5](https://help.qlik.com/pt-BR/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/string/md5.htm) | Calcula o hash da entrada usando MD5 |
| [PARSE_DATETIME](https://help.qlik.com/pt-BR/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/string/parse_datetime.htm) | Analisa uma string em um carimbo de data/hora com fuso horário usando um formato |
| [SUBSTITUIR](https://help.qlik.com/pt-BR/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/string/replace.htm) | Substitui todas as instâncias de search por replace na entrada. Se a pesquisa estiver vazia, insere replace na frente de cada caractere e no final da entrada |
| [REVERSE](https://help.qlik.com/pt-BR/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/string/reverse.htm) | Retorna uma string com os caracteres em ordem inversa |
| [RPAD](https://help.qlik.com/pt-BR/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/string/rpad.htm) | Preenche a string de entrada à direita com uma determinada string de preenchimento até o tamanho |
| [RTRIM](https://help.qlik.com/pt-BR/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/string/rtrim.htm) | Retorna a string fornecida sem espaços em branco à direita |
| [SHA1](https://help.qlik.com/pt-BR/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/string/sha1.htm) | Calcula o hash da entrada usando SHA-1 |
| [SHA256](https://help.qlik.com/pt-BR/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/string/sha256.htm) | Calcula o hash da entrada usando SHA-256 |
| [SHA3_512](https://help.qlik.com/pt-BR/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/string/sha3_512.htm) | Calcula o hash da entrada usando SHA3-512 |
| [SORT_VALUES](https://help.qlik.com/pt-BR/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/string/sort_values.htm) | Retorna os valores ordenados de acordo com a ordem do dicionário |
| [DIVIDIR](https://help.qlik.com/pt-BR/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/string/split.htm) | Retorna a string fornecida dividida pelo delimitador fornecido. Não remove entradas vazias |
| [SPLIT_TO_RECORD](https://help.qlik.com/pt-BR/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/string/split_to_record.htm) | Retorna a string fornecida dividida pelo delimitador fornecido |
| [STRING_FORMAT](https://help.qlik.com/pt-BR/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/string/string_format.htm) | Formata qualquer número de entradas em uma string usando o formato fornecido |
| [STRIP_MARGIN](https://help.qlik.com/pt-BR/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/string/strip_margin.htm) | Para cada linha, remova o prefixo de caracteres de controle ou espaço em branco seguido pelo caractere de margem fornecido |
| [STRIP_PREFIX](https://help.qlik.com/pt-BR/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/string/strip_prefix.htm) | Remova a string de prefixo fornecida do início da string |
| [STRIP_SUFFIX](https://help.qlik.com/pt-BR/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/string/strip_suffix.htm) | Remove a string de sufixo fornecida do final da string |
| [STRPOS](https://help.qlik.com/pt-BR/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/string/strpos.htm) | Retorna a posição inicial da primeira instância de uma determinada substring dentro de uma string |
| [SUBSTR](https://help.qlik.com/pt-BR/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/string/substr.htm) | Extrai uma substring de determinado comprimento a partir de um ponto especificado dentro da string fornecida. |
| [SUBSTRING](https://help.qlik.com/pt-BR/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/string/substring.htm) | Extrai uma substring de determinado comprimento a partir de um ponto especificado dentro da string fornecida. |
| [TRANSLATE](https://help.qlik.com/pt-BR/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/string/translate.htm) | Traduz o valor fornecido usando um determinado dicionário |
| [TRIM](https://help.qlik.com/pt-BR/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/string/trim.htm) | Retorna a string fornecida sem espaços em branco no início ou no final |
| [TRIM_CHARS](https://help.qlik.com/pt-BR/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/string/trim_chars.htm) | Retorna a string fornecida sem caracteres iniciais ou finais |
| [UPPER](https://help.qlik.com/pt-BR/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/string/upper.htm) | Converte a string em letras maiúsculas |
| [UUID_GENERATOR](https://help.qlik.com/pt-BR/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/string/uuid_generator.htm) | Retorna o UUID |
| [XX_HASH](https://help.qlik.com/pt-BR/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/string/xx_hash.htm) | Gera um hash da entrada usando xxHash |