# 字串函數

此區段說明下列字串函數：

| 函數 | 描述 |
| --- | --- |
| [BASE64_DECODE](https://help.qlik.com/zh-TW/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/string/base64_decode.htm) | 將 Base64 字串解碼為字串 |
| [BASE64_TO_HEX](https://help.qlik.com/zh-TW/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/string/base64_to_hex.htm) | 將 Base64 字串轉換為十六進位字串 |
| [BYTES_SUBSTRING](https://help.qlik.com/zh-TW/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/string/bytes_substring.htm) | 傳回輸入的子字串，使用 UTF-8 編碼位元組表示法中的位元組位移。部分字元和無效的 UTF-8 碼點會從結果中移除 |
| [CONCAT](https://help.qlik.com/zh-TW/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/string/concat.htm) | 傳回 string1、string2、...、stringN 的串連。 |
| [日期](https://help.qlik.com/zh-TW/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/string/date.htm) | 將字串轉換為日期 |
| [JOIN_ARRAYS](https://help.qlik.com/zh-TW/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/string/join_arrays.htm) | 使用 MessageFormat 模式，依索引聯結任意數量的陣列 |
| [LENGTH](https://help.qlik.com/zh-TW/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/string/length.htm) | 傳回字串的長度 |
| [LOWER](https://help.qlik.com/zh-TW/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/string/lower.htm) | 將字串轉換為小寫字母 |
| [LPAD](https://help.qlik.com/zh-TW/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/string/lpad.htm) | 使用指定的填補字串將輸入字串向左填補，直到達到指定大小 |
| [LTRIM](https://help.qlik.com/zh-TW/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/string/ltrim.htm) | 傳回不含前置空白字元的指定字串 |
| [MD5](https://help.qlik.com/zh-TW/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/string/md5.htm) | 使用 MD5 雜湊輸入 |
| [PARSE_DATETIME](https://help.qlik.com/zh-TW/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/string/parse_datetime.htm) | 使用格式將字串剖析為含時區的時間戳記 |
| [取代](https://help.qlik.com/zh-TW/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/string/replace.htm) | 將輸入中所有搜尋的執行個體取代為取代。如果搜尋為空，則在每個字元前面以及輸入的結尾插入取代 |
| [反轉](https://help.qlik.com/zh-TW/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/string/reverse.htm) | 傳回字元順序反轉的字串 |
| [RPAD](https://help.qlik.com/zh-TW/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/string/rpad.htm) | 使用指定的填補字串將輸入字串填補到右側，直到達到指定大小 |
| [RTRIM](https://help.qlik.com/zh-TW/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/string/rtrim.htm) | 傳回不含尾隨空白字元的指定字串 |
| [SHA1](https://help.qlik.com/zh-TW/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/string/sha1.htm) | 使用 SHA-1 雜湊輸入 |
| [SHA256](https://help.qlik.com/zh-TW/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/string/sha256.htm) | 使用 SHA-256 雜湊輸入 |
| [SHA3_512](https://help.qlik.com/zh-TW/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/string/sha3_512.htm) | 使用 SHA3-512 雜湊輸入 |
| [SORT_VALUES](https://help.qlik.com/zh-TW/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/string/sort_values.htm) | 傳回依字典順序排序的值 |
| [分割](https://help.qlik.com/zh-TW/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/string/split.htm) | 傳回依指定分隔符號分割的字串。不移除空白項目 |
| [SPLIT_TO_RECORD](https://help.qlik.com/zh-TW/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/string/split_to_record.htm) | 傳回由所提供分隔符號分割的指定字串 |
| [STRING_FORMAT](https://help.qlik.com/zh-TW/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/string/string_format.htm) | 使用指定格式將任意數量的輸入格式化為字串 |
| [STRIP_MARGIN](https://help.qlik.com/zh-TW/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/string/strip_margin.htm) | 對於每一行，移除控制字元或空白字元的前綴，後面接著指定的邊界字元 |
| [STRIP_PREFIX](https://help.qlik.com/zh-TW/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/string/strip_prefix.htm) | 從字串的開頭移除指定的字首字串 |
| [STRIP_SUFFIX](https://help.qlik.com/zh-TW/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/string/strip_suffix.htm) | 從字串的結尾移除指定的字尾字串 |
| [STRPOS](https://help.qlik.com/zh-TW/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/string/strpos.htm) | 傳回指定子字串在字串中第一次出現的起始位置 |
| [SUBSTR](https://help.qlik.com/zh-TW/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/string/substr.htm) | 從指定字串中的特定點開始，擷取特定長度的子字串 |
| [SUBSTRING](https://help.qlik.com/zh-TW/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/string/substring.htm) | 從指定字串中的特定點開始，擷取特定長度的子字串 |
| [翻譯](https://help.qlik.com/zh-TW/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/string/translate.htm) | 使用指定字典翻譯指定值 |
| [TRIM](https://help.qlik.com/zh-TW/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/string/trim.htm) | 傳回不含開頭或結尾空白字元的指定字串 |
| [TRIM_CHARS](https://help.qlik.com/zh-TW/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/string/trim_chars.htm) | 傳回不含開頭或結尾字元的指定字串 |
| [UPPER](https://help.qlik.com/zh-TW/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/string/upper.htm) | 將字串轉換為大寫字母 |
| [UUID_GENERATOR](https://help.qlik.com/zh-TW/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/string/uuid_generator.htm) | 傳回 UUID |
| [XX_HASH](https://help.qlik.com/zh-TW/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/string/xx_hash.htm) | 使用 xxHash 雜湊輸入 |