# 字符串函数

本部分介绍以下字符串函数：

| 函数 | 描述 |
| --- | --- |
| [BASE64_DECODE](https://help.qlik.com/zh-CN/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/string/base64_decode.htm) | 将 base 64 字符串解码为字符串 |
| [BASE64_TO_HEX](https://help.qlik.com/zh-CN/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/string/base64_to_hex.htm) | 将 base 64 字符串转换为十六进制字符串 |
| [BYTES_SUBSTRING](https://help.qlik.com/zh-CN/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/string/bytes_substring.htm) | 返回输入的子字符串，使用 UTF-8 编码字节表示的字节偏移量。结果中会移除部分字符和无效的 UTF-8 码点 |
| [CONCAT](https://help.qlik.com/zh-CN/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/string/concat.htm) | 返回 string1、string2、...、stringN 的连接 |
| [DATE](https://help.qlik.com/zh-CN/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/string/date.htm) | 将字符串转换为日期 |
| [JOIN_ARRAYS](https://help.qlik.com/zh-CN/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/string/join_arrays.htm) | 使用 MessageFormat 模式按索引连接任意数量的数组 |
| [长度](https://help.qlik.com/zh-CN/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/string/length.htm) | 返回字符串的长度 |
| [LOWER](https://help.qlik.com/zh-CN/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/string/lower.htm) | 将字符串转换为小写字母 |
| [LPAD](https://help.qlik.com/zh-CN/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/string/lpad.htm) | 使用给定的填充字符串将输入字符串向左填充，直到达到指定大小 |
| [LTRIM](https://help.qlik.com/zh-CN/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/string/ltrim.htm) | 返回不带前导空格的给定字符串 |
| [MD5](https://help.qlik.com/zh-CN/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/string/md5.htm) | 使用 MD5 对输入进行哈希 |
| [PARSE_DATETIME](https://help.qlik.com/zh-CN/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/string/parse_datetime.htm) | 使用格式将字符串解析为带时区的时间戳 |
| [替换](https://help.qlik.com/zh-CN/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/string/replace.htm) | 将输入中所有搜索实例替换为替换实例。如果搜索为空，则在每个字符前面和输入末尾插入替换 |
| [REVERSE](https://help.qlik.com/zh-CN/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/string/reverse.htm) | 返回一个字符顺序颠倒的字符串 |
| [RPAD](https://help.qlik.com/zh-CN/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/string/rpad.htm) | 使用给定的填充字符串将输入字符串向右填充，直到达到指定大小 |
| [RTRIM](https://help.qlik.com/zh-CN/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/string/rtrim.htm) | 返回不带尾随空格的给定字符串 |
| [SHA1](https://help.qlik.com/zh-CN/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/string/sha1.htm) | 使用 SHA-1 对输入进行哈希处理 |
| [SHA256](https://help.qlik.com/zh-CN/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/string/sha256.htm) | 使用 SHA-256 对输入进行哈希处理 |
| [SHA3_512](https://help.qlik.com/zh-CN/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/string/sha3_512.htm) | 使用 SHA3-512 对输入进行哈希处理 |
| [SORT_VALUES](https://help.qlik.com/zh-CN/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/string/sort_values.htm) | 按字典顺序返回排序后的值 |
| [拆分](https://help.qlik.com/zh-CN/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/string/split.htm) | 返回按提供的分隔符拆分的给定字符串。不删除空条目 |
| [SPLIT_TO_RECORD](https://help.qlik.com/zh-CN/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/string/split_to_record.htm) | 返回给定字符串，按提供的分隔符拆分 |
| [字符串格式](https://help.qlik.com/zh-CN/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/string/string_format.htm) | 使用给定格式将任意数量的输入格式化为字符串 |
| [STRIP_MARGIN](https://help.qlik.com/zh-CN/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/string/strip_margin.htm) | 对于每一行，移除由给定边距字符后跟的控制或空白字符前缀 |
| [STRIP_PREFIX](https://help.qlik.com/zh-CN/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/string/strip_prefix.htm) | 从字符串的开头移除给定的前缀字符串 |
| [STRIP_SUFFIX](https://help.qlik.com/zh-CN/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/string/strip_suffix.htm) | 从字符串的末尾移除给定的后缀字符串 |
| [STRPOS](https://help.qlik.com/zh-CN/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/string/strpos.htm) | 返回给定子字符串在字符串中第一次出现的起始位置 |
| [SUBSTR](https://help.qlik.com/zh-CN/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/string/substr.htm) | 从给定字符串中的指定点开始，提取特定长度的子字符串 |
| [SUBSTRING](https://help.qlik.com/zh-CN/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/string/substring.htm) | 从给定字符串中提取从指定点开始的特定长度的子字符串 |
| [翻译](https://help.qlik.com/zh-CN/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/string/translate.htm) | 使用给定字典翻译给定值 |
| [TRIM](https://help.qlik.com/zh-CN/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/string/trim.htm) | 返回不带前导或尾随空格的给定字符串 |
| [TRIM_CHARS](https://help.qlik.com/zh-CN/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/string/trim_chars.htm) | 返回不带前导或尾随字符的给定字符串 |
| [UPPER](https://help.qlik.com/zh-CN/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/string/upper.htm) | 将字符串转换为大写字母 |
| [UUID_GENERATOR](https://help.qlik.com/zh-CN/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/string/uuid_generator.htm) | 返回 UUID |
| [XX_HASH](https://help.qlik.com/zh-CN/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/string/xx_hash.htm) | 使用 xxHash 对输入进行哈希处理 |