> ## Documentation Index
> Fetch the complete documentation index at: https://help.dingtalk.io/llms.txt
> Use this file to discover all available pages before exploring further.

# Text Functions

> This article details all text functions available on the YiDA platform, including ARRAYGET, CONCATENATE, LEFT, and RIGHT, helping users better understand and use these functions for data processing and text manipulation.

This article lists all text functions available in YiDA.

## Function Overview

| **Function name**                             | **Description**                                                                                                                                            |
| --------------------------------------------- | ---------------------------------------------------------------------------------------------------------------------------------------------------------- |
| [ARRAYGET](/yida/form/mggsmf)                 | Returns the value at a specified position in a dataset.                                                                                                    |
| [CONCATENATE](/yida/form/mbe6045dlu6ebg33)    | Combines multiple text strings into a single string.                                                                                                       |
| [LEFT](/yida/form/xylna43s4gpoyz9k)           | Returns a specified number of characters from the start of a text string. If the text is shorter than the specified length, the original text is returned. |
| [RIGHT](/yida/form/ch2gvwhzh2bn9u82)          | Returns a specified number of characters from the end of a text string.                                                                                    |
| LEN                                           | Returns the number of characters in a text string.                                                                                                         |
| [LOWER](/yida/form/aire3ioygvfi7vul)          | Converts all uppercase letters in a text string to lowercase.                                                                                              |
| [UPPER](/yida/form/fm0og6ccdh0n0q2k)          | Converts all lowercase letters in a text string to uppercase.                                                                                              |
| [MID](/yida/form/pghawu8hdwng91in)            | Returns a specified number of characters from a text string, starting at a specified position.                                                             |
| [PINYINHEADCHAR](/yida/form/dvfmdhg8i3ohg0c4) | Returns the first pinyin letter of each Chinese character in a string, in uppercase.                                                                       |
| [REPLACE](/yida/form/gtz0638tp96gbnhf)        | Replaces part of a text string with another string, based on the specified number of characters.                                                           |
| [REPT](/yida/form/scd5m0bi74omfpyg)           | Repeats text a specified number of times.                                                                                                                  |
| [RMBFORMAT](/yida/form/ff4mghegi9kbsc7m)      | Formats a number in Chinese yuan (RMB) format.                                                                                                             |
| [SEARCH](/yida/form/mhwnrwy04c03o2z4)         | Returns the starting position of text 1 within text 2.                                                                                                     |
| [SPLIT](/yida/form/yf6hkwf5lzcyin93)          | Splits text into an array based on a specified delimiter. Use with ARRAYGET to retrieve the character at a specified position.                             |
| [TEXT](/yida/form/bt0wov266h45hpi4)           | Formats a value as text.                                                                                                                                   |
| [TRIM](/yida/form/tzmpoqk3e4szn7ar)           | Removes spaces from the start and end of a string, while preserving single spaces between words.                                                           |
| [UUID](/yida/form/xb7gg8vrhik5yg5s)           | Generates a unique string and assigns it to a single-line text field.                                                                                      |
| [VALUE](/yida/form/awk6sfyg9vcqe1g1)          | Converts text to a number. Typically used when data has already been entered and needs to be recalculated.                                                 |