Text Functions

This article lists all text functions available in YiDA.

Function Overview

Function name	Description
ARRAYGET	Returns the value at a specified position in a dataset.
CONCATENATE	Combines multiple text strings into a single string.
LEFT	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	Returns a specified number of characters from the end of a text string.
LEN	Returns the number of characters in a text string.
LOWER	Converts all uppercase letters in a text string to lowercase.
UPPER	Converts all lowercase letters in a text string to uppercase.
MID	Returns a specified number of characters from a text string, starting at a specified position.
PINYINHEADCHAR	Returns the first pinyin letter of each Chinese character in a string, in uppercase.
REPLACE	Replaces part of a text string with another string, based on the specified number of characters.
REPT	Repeats text a specified number of times.
RMBFORMAT	Formats a number in Chinese yuan (RMB) format.
SEARCH	Returns the starting position of text 1 within text 2.
SPLIT	Splits text into an array based on a specified delimiter. Use with ARRAYGET to retrieve the character at a specified position.
TEXT	Formats a value as text.
TRIM	Removes spaces from the start and end of a string, while preserving single spaces between words.
UUID	Generates a unique string and assigns it to a single-line text field.
VALUE	Converts text to a number. Typically used when data has already been entered and needs to be recalculated.